You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Supplemental Data's script - DATE_DIFF using MONTH type return incorrect result

in Financial Consolidation and Close 2 comments

The test case is input Dec 31,2022 (Start Date) and Dec 31,2023 (End Date). Using function DATA_DIFF with "MONTHS" type will return 12.329 (DIFF_MONTH). How does this number calculated?


The day is correctly calculated to 365 (DIFF_DAY).

The calculation is below:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!