Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Calculations on date fields – is it possible?

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 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