The SQL export outputs the dateadd field in the form of 'MM/DD/YYY' while mySQL (and I'm guessing other SQL servers) require date type data to be in the form of 'YYYY-MM-DD'. This problem leads to mySQL inputing dates as "0000-00-00'. Hope this can be changed easily.
Thanks,
Ryan
P.S. Here is an example date type input, right and wrong:
WRONG: '8/19/2002'
RIGHT: '2002-08-19'
SQL export bug (latest version of ANTMC)
Actually it uses the date format defined in your Windows preferences (Regional Options, in the control panel).
So if you want to change the way it builds the date string, you have to change it in Windows.
In the next version I will try to add an option to force the date format.
PS: close the program before changing the parameter in Windows, because Windows settings are read when the program starts.
So if you want to change the way it builds the date string, you have to change it in Windows.
In the next version I will try to add an option to force the date format.
PS: close the program before changing the parameter in Windows, because Windows settings are read when the program starts.