asked on July 29, 2025
We are developing custom api.
db is postgresql, and the column indicating time is timestamp data type.
And it is stored in the following format.
2025-07-29 00:00:00.000
1. Separate this date in years/months/days on the Flex Monster,
2. Detach fields modals, such as month, date, year under date folder
I want to implement the above two.
⋅ July 29, 2025
Hello, Jhshin!
Thank you for reaching out to us.
Kindly note that Flexmonster can separate the date field into date.year, date.month, and date.day fields, but this feature is available for JSON and CSV data sources, where all the data is loaded into the client side, and we can preprocess it.
For the data that is fetched from the server, we recommend breaking the dates into three separate fields on the server and then making the desired hierarchy on the client side using mapping.
Here is a JSFiddle example of how to configure the multilevel hierarchy on the client: https://jsfiddle.net/flexmonster/nerdf12L/.
We also recommend reading our Date and time formatting guide for more details about working with dates: https://www.flexmonster.com/doc/date-and-time-formatting/.
Hope you will find our answer helpful.
Kind regards,
Solomiia
