belovedcej
Programmer
I have a query that the user frequently exports to excel. It's a linked db to SQL server, if that makes any difference.
We use "1/1/1900" as a default in date fields when the user does not have a date, so a number of our queries show that date. What's odd is that when exported to excel, anything with a date of "1/1/1900" appears with a date of "1/2/1900". (by the way, they are datetime fields, so the value is actually 1/1/1900 00:00:00.)
It makes us wonder at the integrity of the other dates when, though they appear to be right so far.
Does anyone have any ideas as to why this is happening?
We use "1/1/1900" as a default in date fields when the user does not have a date, so a number of our queries show that date. What's odd is that when exported to excel, anything with a date of "1/1/1900" appears with a date of "1/2/1900". (by the way, they are datetime fields, so the value is actually 1/1/1900 00:00:00.)
It makes us wonder at the integrity of the other dates when, though they appear to be right so far.
Does anyone have any ideas as to why this is happening?