inserting date using date serial number

Hi. In order to fix a bug in my program, I need to use a date serial number to get the date out of an excel file. If I take a formatted date, it causes problems because different users have different regional settings, so I could end up with yyyy-mm-dd or dd/mm/yyyy or about any other combination.

My question is how do I either reconstruct a date in the format yyyy-mm-dd, or use the serial number ( 36998 for example) to insert a date into a MSSQL7 database?

Thanks for any suggestions.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!