Excel’s Date(), Eomonth() and Edate() are correctly calculate the beginning and the end dates for the months of 1900 year.
Why QM’s Date(), Eomonth() and Edate() can’t do the same? Or what am I doing wrong?
Thank you in advance for your help.
See the model file:
QM5.3.4 Date Functions wrong calcs. SAU.model
The issue is that there is a bug in the Excel date in the year 1900. Excel incorrectly counts 1900 as a leap year. See https://support.microsoft.com/en-us/kb/214326. This can be seen in the model I am attaching, The last day of February is 59 and the first day of march is 61. Quantrix made a conscious decision to not replicate that bug, so dates before March 1, 1900 will not match between Quantrix and Excel.
Thank you for your question.