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.