Hi
I currently have table that has a date field in the following format
yyyy-mm-dd
The problem is that when I export it to csv it becomes dd/mm/yyyy 00:00
I need the date to retain the format yyyy-mm-dd but the only way I can do this is to make it a text file prior to export. This is a problem as it then exports the field as a text field which is then unrecognised by the system I am trying to the data into as it expecting to find numbers and not text in this field.
The only way I can find to get around this is to export it as text and then use notepad to do a find and replace to remove the quotes around the field. this is time consuming when handling a large number of records
Has anyone got a alternative method that thay could suggest-
I currently have table that has a date field in the following format
yyyy-mm-dd
The problem is that when I export it to csv it becomes dd/mm/yyyy 00:00
I need the date to retain the format yyyy-mm-dd but the only way I can do this is to make it a text file prior to export. This is a problem as it then exports the field as a text field which is then unrecognised by the system I am trying to the data into as it expecting to find numbers and not text in this field.
The only way I can find to get around this is to export it as text and then use notepad to do a find and replace to remove the quotes around the field. this is time consuming when handling a large number of records
Has anyone got a alternative method that thay could suggest-
