I have embedded classic asp code into WSS using “page viewer” web part. Which is working fine. The problem is with the date format. In asp application I require the date to be in dd/mm/yyyy format. If
I run the asp code within WSS the date format is mm/dd/yyyy while if I run it on its own (outside WSS), the date appears as how I wanted.
FYI, I have only got WSS not SharePoint Portal. According to someone’s advice in one of the forum, I have even tried changing the date format under “regional settings” to “English (Australia)” but no use.
I am still getting an error saying:
Microsoft OLE DB Provider for SQL Servererror '80040e07'
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
Just because the date is not in dd/mm/yyyy format. Please help.
rrobet
Member
10 Points
48 Posts
Date format in WSS
Mar 15, 2007 11:09 AM|LINK
I have embedded classic asp code into WSS using “page viewer” web part. Which is working fine. The problem is with the date format. In asp application I require the date to be in dd/mm/yyyy format. If I run the asp code within WSS the date format is mm/dd/yyyy while if I run it on its own (outside WSS), the date appears as how I wanted.
FYI, I have only got WSS not SharePoint Portal. According to someone’s advice in one of the forum, I have even tried changing the date format under “regional settings” to “English (Australia)” but no use. I am still getting an error saying:
Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
Just because the date is not in dd/mm/yyyy format. Please help.