Method onBeforeValueChange returns date in strange format

By using "onBeforeValueChange" I try to get old and new values from cell to compare with some dates, but method returns dates in strange format.

Please, take a look at the snippet
https://snippet.webix.com/hzo4j16f

Comments

  • edited July 30

    Hello @Mikalai,

    By using "onBeforeValueChange" I try to get old and new values from cell to compare with some dates, but method returns dates in strange format.

    In fact, the returned value is the date presented in Excel date format. You can use a custom function and convert the Excel date to the standard JS Date object: https://snippet.webix.com/crgnovb7.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion