date format not 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.

Thanks

MS SQL Server has a very dodgy way of saving date/time fields.

If I remember rightly it saves the time as well as the date in the format dd/mm/yy hh:mm:ss

It's caused me massive headaches in the past.

Somebody else might bebale to shed more light on the matter.