skalag
04-28-2003, 03:57 PM
I am going crazy over this date format problem, i send date to DB from update or addnew page
DB = set to short date
PC system = set to short date
FormatDateTime = set to short date (FormatDatetime(date,2)
Expected result as dd/mm/yy, but this does not work
i then added this at top of update DB page
Session.LCID=2060
Now Dates change format every time i go through that page From
28/04/03 to 28/04/2003 - not too serious there but i am now using a new process and this date has to be right and the above does not work right, every time i submit to database the date comes back displayed as dd/mm/yyyy, next time i submit it comes back as m/dd/yyyy, next time it is as dd/mm/yyyy again.... is there any way i can fix this permanently, short of changing date field to String type or something just for peace?
DB = set to short date
PC system = set to short date
FormatDateTime = set to short date (FormatDatetime(date,2)
Expected result as dd/mm/yy, but this does not work
i then added this at top of update DB page
Session.LCID=2060
Now Dates change format every time i go through that page From
28/04/03 to 28/04/2003 - not too serious there but i am now using a new process and this date has to be right and the above does not work right, every time i submit to database the date comes back displayed as dd/mm/yyyy, next time i submit it comes back as m/dd/yyyy, next time it is as dd/mm/yyyy again.... is there any way i can fix this permanently, short of changing date field to String type or something just for peace?