Revmove Time Stamp

[Merlin]

I am trying to remove the time stamp from a csv export but can't seem to do it. It comes out with the date and 00:00:00 trailing behind. I am trying to upload the export into Lawson but it fails due to this added info..it only requires date.

Any ideas out there?

Thank you.

Merlin

 

[antomack]

Create a query with all the details you want to export and format the date field you have as below, then export the details from the query rather than the table.

format([DateField],"dd/mm/yyyy")

You can change the format to whatever suits your requirements.