Skip to main content
Known Participant
Apr 13, 2021 9:07 AM UTC
Question

How to use the datetext fonction with specific timezone ?

Hi,

I'm trying to get the French month name of the current date but I don't succeed :

    datetext(local(today(), "GMT+01:00"), "MMMM"),
    datetext(local(today(), "GMT+02:00"), "MMMM"),   

Every timezone I'm testing returns "April", but I need "Avril". Am I using the bad timezone ?

Central European Standard Time = GMT+1
Central European Summer Time = GMT+2

2 replies

stefanhelzle0001
Brainy
Apr 13, 2021 11:35 AM UTC

I think this does not depend on the time zone but on the language settings in your user profile.

Known Participant
Apr 13, 2021 11:44 AM UTC

Oups...

You're right, thank you for the tip Stefan.