Date format français

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Date format français

Post by pasbonte » 2018-09-06 07:09

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

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 377
Joined: 2018-04-01 10:12

Re: Date format français

Post by pböttcher » 2018-09-07 08:40

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')

pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Re: Date format français

Post by pasbonte » 2018-09-07 09:44

Bonjour

Oui j'ai essayé mais rien.

merci

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 377
Joined: 2018-04-01 10:12

Re: Date format français

Post by pböttcher » 2018-09-07 10:16

Hi,
did you re-generate/reload your application?
Can you post the screenshots of how it looks like in AppGini and in you application.

pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Re: Date format français

Post by pasbonte » 2018-09-27 06:40

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

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 377
Joined: 2018-04-01 10:12

Re: Date format français

Post by pböttcher » 2018-09-27 07:53

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?

pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Re: Date format français

Post by pasbonte » 2018-09-27 07:55

Not screen copies are not good I tried both 1 and 2, I will try the trick dates.

pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Re: Date format français

Post by pasbonte » 2018-09-27 08:04

I tried with date 1 and date 2 and with the field in DATETIME and it is always in english format ...

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 377
Joined: 2018-04-01 10:12

Re: Date format français

Post by pböttcher » 2018-09-27 08:39

Hi, did you restart the AppGini Application after changing the dataformat.cfg ? What version of AppGini are you working with?

pasbonte
Veteran Member
Posts: 53
Joined: 2013-02-06 09:49

Re: Date format français

Post by pasbonte » 2018-09-27 13:08

I restarted APPGINI and still the wrong date, and my version is recent: 5.72

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 377
Joined: 2018-04-01 10:12

Re: Date format français

Post by pböttcher » 2018-09-27 16:25

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?

User avatar
baudwalker
Veteran Member
Posts: 98
Joined: 2015-02-03 08:08
Location: Bellingen NSW Australia

Re: Date format français

Post by baudwalker » 2018-09-28 00:57

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 725 times

Post Reply