Skip to main content
Known Participant
April 13, 2021
Question

How to use the datetext fonction with specific timezone ?

  • April 13, 2021
  • 2 replies
  • 0 views

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
April 13, 2021

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

Known Participant
April 13, 2021

Oups...

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