Page 1 of 1

Date format français

Posted: 2018-09-06 07:09
by pasbonte
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

Re: Date format français

Posted: 2018-09-07 08:40
by pbottcher
Hi,
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')

Re: Date format français

Posted: 2018-09-07 09:44
by pasbonte
Bonjour

Oui j'ai essayé mais rien.

merci

Re: Date format français

Posted: 2018-09-07 10:16
by pbottcher
Hi,
did you re-generate/reload your application?
Can you post the screenshots of how it looks like in AppGini and in you application.

Re: Date format français

Posted: 2018-09-27 06:40
by pasbonte
Hello
I can not display dates on the table in French format dd / mm / yyyy
I changed the dataformat.cfg file
and nothing.

Image
Image
Image
Image

Re: Date format français

Posted: 2018-09-27 07:53
by pbottcher
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?

Re: Date format français

Posted: 2018-09-27 07:55
by pasbonte
Not screen copies are not good I tried both 1 and 2, I will try the trick dates.

Re: Date format français

Posted: 2018-09-27 08:04
by pasbonte
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

Posted: 2018-09-27 08:39
by pbottcher
Hi, did you restart the AppGini Application after changing the dataformat.cfg ? What version of AppGini are you working with?

Re: Date format français

Posted: 2018-09-27 13:08
by pasbonte
I restarted APPGINI and still the wrong date, and my version is recent: 5.72

Re: Date format français

Posted: 2018-09-27 16:25
by pbottcher
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?

Re: Date format français

Posted: 2018-09-28 00:57
by baudwalker
Sorry to intrude, but I normally set the date format on the first page of AppGini.

date format.PNG
date format.PNG (58.25 KiB) Viewed 4818 times