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: 162
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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Date format français

Post by pbottcher » 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')
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.

pasbonte
Veteran Member
Posts: 162
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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Date format français

Post by pbottcher » 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.
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.

pasbonte
Veteran Member
Posts: 162
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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Date format français

Post by pbottcher » 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?
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.

pasbonte
Veteran Member
Posts: 162
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: 162
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 ...

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Date format français

Post by pbottcher » 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?
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.

pasbonte
Veteran Member
Posts: 162
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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: Date format français

Post by pbottcher » 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?
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.

User avatar
baudwalker
Veteran Member
Posts: 188
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 4820 times

Post Reply