How to use the datetext fonction with specific timezone ?

Question

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

Stefan Helzle · Accepted Answer

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

How to use the datetext fonction with specific timezone ?

Top Replies