Conversion of 01/01/1900 in Excel

Support
1

Hi,
It looks like EM converts 01/01/1900 in Excel, to 31/12/1899 when inserting into a database.
Is there any way around this in EM?

Thanks
Scott

1900%20conversion

2

Hi Scott,

it’s a known feature of Excel that was introduced in order to comply with a bug in Lotus 1-2-3 which treated year 1900 as a leap year while in fact it’s not.

For now, for all dates in January and February 1900 imported from Excel add an extra day in EasyMorph before exporting to a database. You can use an expression similar to the one below:

if([Date] < #1900-03-01, [Date]+1, [Date])