Hello
I wish to display in my table the date in French format: DAY MONTH YEAR
I created a date template in dataformat.cfg:
European Short Date / Time (example: 2008-03-28 13:00); DATE_FORMAT (%% FIELD %%, '% Y-% m-% d% H:% i')
FRENCH DATE; DATE_FORMAT (%% FIELD %%, '% d-% m-% y') but this is still displayed in English in my table.
Thanks for your help
Date format français
Re: Date format français
Hi,
did you put the spaces in your file like in the post? If yes, try the same without the spaces
did you put the spaces in your file like in the post? If yes, try the same without the spaces
Code: Select all
FRENCH DATE; DATE_FORMAT(%%FIELD%%, '%d-%m-%y')
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Date format français
Bonjour
Oui j'ai essayé mais rien.
merci
Oui j'ai essayé mais rien.
merci
Re: Date format français
Hi,
did you re-generate/reload your application?
Can you post the screenshots of how it looks like in AppGini and in you application.
did you re-generate/reload your application?
Can you post the screenshots of how it looks like in AppGini and in you application.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Date format français
Hello
I can not display dates on the table in French format dd / mm / yyyy
I changed the dataformat.cfg file
and nothing.
I can not display dates on the table in French format dd / mm / yyyy
I changed the dataformat.cfg file
and nothing.
Re: Date format français
Hi,
in the dataformat.cfg file you have "FRENCH DATE1" and "FRENCH DATE2", but in AppGini you have the reference to "FRENCH DATE". Can you check this.
Also, I think that the conversion is only working for date/time fields, not for date only fields. Can you change your field definition and check?
in the dataformat.cfg file you have "FRENCH DATE1" and "FRENCH DATE2", but in AppGini you have the reference to "FRENCH DATE". Can you check this.
Also, I think that the conversion is only working for date/time fields, not for date only fields. Can you change your field definition and check?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Date format français
Not screen copies are not good I tried both 1 and 2, I will try the trick dates.
Re: Date format français
I tried with date 1 and date 2 and with the field in DATETIME and it is always in english format ...
Re: Date format français
Hi, did you restart the AppGini Application after changing the dataformat.cfg ? What version of AppGini are you working with?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Date format français
I restarted APPGINI and still the wrong date, and my version is recent: 5.72
Re: Date format français
Hi,
that is very strange. On my system it works fine.
Can you please check the file CR_REUNION_view.php
and look for the
$x->QueryFieldsTV array. You should see something like :
DATE_FORMAT(`CR_REUNION`.`REUNION_DATE`, '%d-%m-%y')" => "REUNION DATE"
Can you post what is there?
Can you change the assignemt for the date, regenerate your app and post the change?
that is very strange. On my system it works fine.
Can you please check the file CR_REUNION_view.php
and look for the
$x->QueryFieldsTV array. You should see something like :
DATE_FORMAT(`CR_REUNION`.`REUNION_DATE`, '%d-%m-%y')" => "REUNION DATE"
Can you post what is there?
Can you change the assignemt for the date, regenerate your app and post the change?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
- baudwalker
- Veteran Member
- Posts: 188
- Joined: 2015-02-03 08:08
- Location: Bellingen NSW Australia
Re: Date format français
Sorry to intrude, but I normally set the date format on the first page of AppGini.