I am trying to write a date : 25/02/2002 (25-Feb-2002) to an SQL 7.0 database. For some reason, the date gets stored in the database as : 25/01/2000. I tried using the <Format datetime:%d/%m/%Y> tag but no use. Here are some more details:
- SQL datatype is datetime
- SQL 7.0
- SQL username that is used for the DSN has default language set up as BRITISH English
- I changed datatype of the SQL column to varchar (20). No use. Still defaults month to Jan and Year to 2000
- Tried inserting as <@ARG DatefromForm> into insert statement. No use.
- Tried storing it to variable @@DateFromForm. No use.
- Tried breaking up day month and year in different field variables. Like day, month and year and then storing them together in the insert action. No use. Still defaults month to Jan and Year to 2000
Any suggestions would be welcome and highly appreciated.
Thanks
- Vicky
