Whether QM correctly calculates dates?

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
0

Hi all.
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

Edited question
0

Dear Sau,

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.

Brian

You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions