Calculations on date fields - is it possible?

Answered
Chris asked on August 7, 2018

We have a lot of project data with columns like Start Date and End Date. Is it possible to create a duration calculation using the Flexmonster interface?

1 answer

Public
Tanya Gryshko Tanya Gryshko Flexmonster August 8, 2018

Hello, Chris,
Thank you for writing to us.
There can be the following approach to duration calculation: pre-process data on your side to get the duration in milliseconds and pass it as a new field. This field can have "type": "time". Also, our team will add timePattern property which will allow formatting for "type": "time".
Would such scenario work for you?
Regards,
Tanya

Please login or Register to Submit Answer