>Hi
>
>What's wrong with the following date and time values while compiling application.
>
>Compiling d:\village\progs\datime.prg
>INSERT INTO MyTable (dtValue, dValue) VALUES ({12/11/2000 02:59:02 AM},{12/11/2000})
>Error in line 111: Ambiguous date/datetime constant. Use the format:
> {^yyyy-mm-dd[,][hh[:mm[:ss]] [a|p]]}
>
>Thanks/Regards - Saif
If you check the error message, you will notice that the datatime format is not accepted. There are many reasons for this change, among other the Y2K problem (year 2000), and to avoid problems with different date and time formats. Check Strictdate in help for more info.
INSERT INTO MyTable (dtValue, dValue) VALUES ({^2000-12-11 02:59:02a},{12/11/2000})
NB! Your values clearly shows why the change was made, since it's impossiblke for me to know whether 12/11/2000 means December 11th or November 12th. So you may have to swap the values 11 and 12.