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
⋅ August 7, 2025
Hello, Jhshin!
Hope you are doing well.
We are wondering if you had a chance to look through the provided information about creating a multilevel date hierarchy using custom data source API.
Please let us know if you have any further questions.
Kind regards,
Solomiia
⋅ August 14, 2025
Hello, Jhshin!
Hope you are having a great week.
Just checking in to ask if the suggested approach about creating a multilevel date hierarchy using the custom data source API was helpful.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
