Page 2 of 2 < 1 2
Topic Options
#57647 - 08/27/20 03:29 PM Re: Covert date to french [Re: Luc]
jouberto Offline
OL Toddler

Registered: 04/18/18
Posts: 49
Hi Luc,

I will try to upload screenshots showing the right order to place the functions in the list and a syntax example to use them. These functions require you pass as a parameter the date format. As J-C mentioned at the top of the thread, the Date() function I use in my call for today's date, will have a format based on regional settings. Mine are set to YYYY-MM-DD, but yours could be different, just match what you have when writing the call to the function.

Top
#57648 - 08/27/20 03:42 PM Re: Covert date to french [Re: Luc]
jouberto Offline
OL Toddler

Registered: 04/18/18
Posts: 49
Putting these lines in a custom data selection will produce the desired dates in English and French. I couldn't find an online repository so I can link my screenshots to you, so I can only give you the below tips.

Code:
=@FormatDate(Date(false),'YYYY-MM-DD')

Code:
=@FormatDateF(Date(false),'YYYY-MM-DD')


The order for the functions should be:
-NormalizeDate
-GetDayName
-GetMonthName
-GetDayNameF
-GetMonthNameF
-FormatDate
-FormatDateF
Open each one starting from the top, and simply click ok, so they are "loaded" properly, otherwise you might get errors trying to call them.

Top
Page 2 of 2 < 1 2