How to work with date and time fields

Hello,

Thank you for contacting us.

Please find the answers to your question below:

1. Kindly note that Flexmonster is expected to receive a Unix time stamp in milliseconds. It means that to display 1667542118000 as 2022-11-04, the timestamp should be multiplied by 1000.
Also, it is only possible to set one type per field. We recommend using mapping to customize the presentation of the dates. To make date fields be interpreted as a date, you must define the data type as a date. For example, "type": "datetime" is used to display 1667542175000 as 04/11/2022 08:09:35. However, you can set a special date format. For example,

"Date": {
    type: "datetime",
    format: "yyyy-MM-dd hh:mm:ss"
},

Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/c6donx1u/ 

2. If you want to have a field with the number of days between two dates in a large dataset, the recommended way is to do all the calculations on your server side and pass the results to Flexmonster. For instance, you can preprocess the data by calculating the difference between dates and pass those numbers in the new field "Difference between the dates".
Alternatively, you can create a calculated value based on the fields with the "datetime" type. Please note that with this approach, those values will be calculated on the client side. You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/h42br5Lk/ 
When you have this field in the dataset, you can use Conditional Formatting to highlight the necessary cells.

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia