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?
Thank you for the question.
Actually, you need to change the default date type to
ds+ (more details about date types are here: https://www.flexmonster.com/doc/data-types-in-csv/).
Using SQL query you can do it as follows:
SELECT date as 'D+Date', ... FROM ...
Please let us know if it helps.
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?
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.
Thanks Vera, I have uploaded latest translation files and everything is translated now.