TODAY() formula doesn't work?

Tags: #<Tag:0x00007f2492b4e138>

Hello,
it looks like TODAY() formula doesn’t work?


I have date column and if I use TODAY() it calculates somehow numbers:

Do I understand correctly that the current date should be substituted for this formula?

Best regards,
Iryna

Hi @iryna.biletchenko

This issue was fixed in the latest release. Reference: https://github.com/handsontable/handsontable/issues/8634

What version do you use?

Hi @aleksandra_budnik

Thank you for your reply.

We are using the latest version, 12.0.1.
But TODAY() doesn’t work correctly.

Could you share more details about that report? Do you refer to the numeric value that we get instead of the string with date format?

This is an openformula standard that we follow for the Hyperformula engine. Here are the details https://www.oasis-open.org/committees/download.php/16826/openformula-spec-20060221.html#TODAY

I also have an example here https://jsfiddle.net/rcnmpfxt/10/ how to keep the TODAY() formula but show a more friendly-looking date for the user.

Hi @aleksandra_budnik,
If we understand correctly Hyperformula uses “serial dates” format for easier calculations, but Handsontable does not process it and shows the result as is.
We suggest that we have to handle the date format for display on our own, like in your example ( https://jsfiddle.net/rcnmpfxt/10/).
Thanks.

Yes, that is correct. Handsontable does not add any logic for date formatting from the formula serial. But as shown in the example you can use a custom renderer to create a date string.

Ok. Thanks for help!

Have a good day!

Thank you :slight_smile: Same you you, @iryna.biletchenko