no description about 'Units' from "DATEDIF(Date1, Date2, Units)"

[cuihee]

Page URL

https://hyperformula.handsontable.com/guide/built-in-functions.html#list-of-available-functions

Improvement description

DATEDIF | Calculates distance between two dates, in provided unit parameter. | DATEDIF(Date1, Date2, Units) -- | -- | --

check resource code: es/interpreter/plugin/DateTimePlugin.js line 261 "switch (unit) { case 'M':"

[AMBudnik]

Thank you for sharing the issue report, @cuihee

You are right. To provide a comprehensive guide, we'd need to either direct users to another resource or list them ourselves. Now we only show possible units within the tests scenarios like https://github.com/handsontable/hyperformula/blob/76aaae5b5f5c02de1d1a365b7407d99789467650/test/interpreter/function-datedif.spec.ts#L10

[sequba]

Hi @cuihee

I am happy to share the good news. We just launched HyperFormula v3.1.0, which fixes this issue.

Here, you can read more about the changes in this version.