Wednesday, March 7, 2012

date format cannot be saved

Hi guys, I was doing some changes on my asp web pages, I added new field expiry date that will be scanned into the system in format ddmmyyyy but it can't save as i am gettting that message that char can't be converted into datetime as date time was out of range.

I have added this into my asp pages <% Session.LCID = 3081 %> and changed the sql server regional setting setting the date to dd/mm/yyyy I can't set it to ddmmyyyy as there is not option without "/".

Could somebody help me as this is quite frustrating.

ThanksBefore you INSERT the data, change the format. That's fairly easy to do if these are asp pages.

No comments:

Post a Comment