I am tyring to save some data to a Mysql database that uses the YYYY-DD-MM date format. I have tried to use the format command... format(TDATE, "#yyyy-mm-dd#", ".") in various configuations, but can't make it work.
The program takes information from a text file and saves it into the database, but the database will not accept date data unless it is in that format. The text file has the date as dd-mm-yyyy... I can not change the text file format, so I must reconfigure the date before saving to the database.
Any suggestions?
Thanks