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
