import - date field formats
Posted: Wed Nov 21, 2007 11:16 am
Hi,
The dates come out of our client database in the format: dd/mm/yy HH:MM - is it possible to easily support this for import because I have little ability to manipulate the dates as they are extracted and at the moment I would have to do a manual search & replace + some string manipulation in the csv file.
That's the only thing stopping the import being completely 'painless'.
We're using 5.3.0
Thanks
Edit: Managed to get the dates as dd/mm/yyyy so can the delimiter be picked from a list?
The dates come out of our client database in the format: dd/mm/yy HH:MM - is it possible to easily support this for import because I have little ability to manipulate the dates as they are extracted and at the moment I would have to do a manual search & replace + some string manipulation in the csv file.
That's the only thing stopping the import being completely 'painless'.
We're using 5.3.0
Thanks
Edit: Managed to get the dates as dd/mm/yyyy so can the delimiter be picked from a list?