asked on March 6, 2019
I use a MySQL database as a datasource, and I have a column which is a datetime in MySQL.
In FlexMonster, this column is split into year, month and day, which is not convenient.
I would like to have it as a single column, and be able to use the new 2.7 filters on it (I already upgraded to 2.7).
How to proceed?
⋅ March 8, 2019
Hello Eric,
Thank you for the question.
Actually, you need to change the default date type to D+, D4+ or ds+ (more details about date types are here: https://www.flexmonster.com/doc/managing-data-presentation-csv/).
Using SQL query you can do it as follows:
SELECT date as 'D+Date', ... FROM ...
Please let us know if it helps.
Regards,
Ian
⋅ March 11, 2019
Hello Ian,
It works nicely, thank you. Date is displayed as expected, and the new date filter is available.
I noticed the date filter is not yet translated in French.
Do you have a schedule for this?
⋅ March 13, 2019
Hello Eric,
Thank you for writing to us.
We have already updated our localization files to be compatible with the version 2.7.
Flexmonster's up-to-date localization files can be found on our GitHub repository.
You can get the needed localization file from here.
You can also add custom translations. Here is a link to our guide how the pivot table can be localized.
Please let us know if everything worked.
Best Regards,
Vera
⋅ March 13, 2019
Thanks Vera, I have uploaded latest translation files and everything is translated now.
This question is now closed
