Man I'm loving the dates in my code.
Issue 1: I'm in New Zealand and we format our dates dd/mm/yyyy
Issue 2: IsDate doesn't seem to work!
Issue 1: faq333-3194 shows me how to set the locale... so I set it for NZ and that displays 28/03/2004 but when I try to enter that as a date it :
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting datetime from character string.
Issue 2:
my code looks like:
case "save":
if not IsDate(SendDate) then errMsg = errMsg & "Please enter a valid Date format.<br> Either 8 Mar(ch) 2003 or 03/08/2003. <br>"
if I type in 'asdasdhk' it sends the error msg correctly but
if I type in 28/03/2003 (a valid format here) the browser errors with
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting datetime from character string.
I guess this is correct as it thinks I'm trying to enter the 3rd of 28thMonth... but is there a way I can get it to error nicely?
But I thought that setting my locale would help ?
I want to be able to enter dates as 28 march 2003, 28/03/2003 and march 28 2003. I don't really want to be setting the date manually to dd/mm/yyyy as this app is going to be used in the states as well.. I can deal with changing the locale in a page but not manually fooling with the dates and ending up with 3/4/5 different verisons
And Ideas?
Thanks
Issue 1: I'm in New Zealand and we format our dates dd/mm/yyyy
Issue 2: IsDate doesn't seem to work!
Issue 1: faq333-3194 shows me how to set the locale... so I set it for NZ and that displays 28/03/2004 but when I try to enter that as a date it :
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting datetime from character string.
Issue 2:
my code looks like:
case "save":
if not IsDate(SendDate) then errMsg = errMsg & "Please enter a valid Date format.<br> Either 8 Mar(ch) 2003 or 03/08/2003. <br>"
if I type in 'asdasdhk' it sends the error msg correctly but
if I type in 28/03/2003 (a valid format here) the browser errors with
Microsoft OLE DB Provider for SQL Server error '80040e07'
Syntax error converting datetime from character string.
I guess this is correct as it thinks I'm trying to enter the 3rd of 28thMonth... but is there a way I can get it to error nicely?
But I thought that setting my locale would help ?
I want to be able to enter dates as 28 march 2003, 28/03/2003 and march 28 2003. I don't really want to be setting the date manually to dd/mm/yyyy as this app is going to be used in the states as well.. I can deal with changing the locale in a page but not manually fooling with the dates and ending up with 3/4/5 different verisons
And Ideas?
Thanks