HI Guys,
I am using MSSQL (not mysql) and have problem with dates...(yes i know!)
I succesfully display the date the way i want from the data stored in my DB using this.
select *,CONVERT(char(10), [date], 105)AS date etc....
This date is displayed in a <input> and users are allowed to edit it.
This is where the problem starts.
As i convert my date succesfully to display it, how can I:
1/ Check back fro correct date format
2/ Update my MSSQL field with the correct date format?
I already had a look at:
http://www.databasejournal.com/features ... _2197931_2
and
http://www.epsilon-logic.net/OQBHelpDoc ... ctions.htm
looking more for an answer than aguidance!
thanks in advance
s
The date...AGAIN!
Moderator: General Moderators