asked on February 24, 2025
How can I create a calculated field using IF statement with two "date string" field?
IF ( max(datefield1) > max(datefield2), max(datefield1), max(datefield2))
I tried it but value not displayed as "date string".
Kind regards,
Zoltan
⋅ February 25, 2025
Hello Zoltan,
Thank you for contacting us.
Currently, Flexmonster only supports displaying dates in the calculated values columns in a timestamp format. If you want to display these values in a date string format, we recommend using the customizeCell method to convert the timestamp to a date string. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/b7h6skqp/. You can find more details about the customizeCell API call in our documentation: https://www.flexmonster.com/doc/customizing-grid/.
Alternatively, you can preprocess data before passing it to Flexmonster and add a new column containing date values based on this formula.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ February 27, 2025
Hello Naida,
I tried your solution and it works. Thank you.
Kind regards,
Zoltan
⋅ February 28, 2025
Hello, Zoltan!
Thank you for your feedback.
We are glad the proposed solution for date formatting with calculated values worked for you.
Please let us know if more questions arise.
Best regards,
Maksym
