Dear all,
I have a web application build with ASP 1.1 which has a querry form based on
fields where users need to enter a date/time value for data collection.
On my Web server the date time foprmat is set with US (english).
The final querry will be something like :
" select * from Table 1 where DATE_TIME > @DateTimeParam"
What is the way to control that the value enter in the DAte/tiome tex box
correspond to proper date format and will return correct information based on
server date/time format ?
For example if I pass the date in MM/dd/yyyy and my server is set o use
dd/MM/yyyy, then if you enter 2/3/2006 or its interprated on the server as
3/2/2006 I will not have correct data.
How can I check that ??
Thanks for your help
regards
Serge