I have managed to export a table to a delimited text file.
In the table there is a date field but I need it in the format dd/mm/yyyy. I therefore cannot use any of the default formats so in the format field I entered dd/mm/yyyy. The table now displays the date correctly but on export it also includes the time.
How can I format the date field so that it does not export the time only the date in the above format.
Thanks in anticipation
Regards
Matt
matt@begg-uk.co.uk
In the table there is a date field but I need it in the format dd/mm/yyyy. I therefore cannot use any of the default formats so in the format field I entered dd/mm/yyyy. The table now displays the date correctly but on export it also includes the time.
How can I format the date field so that it does not export the time only the date in the above format.
Thanks in anticipation
Regards
Matt
matt@begg-uk.co.uk