Hello how can I specify the current time zone.
I´m using the formula NOW(“YY/MM/DD - HH:MM”) but the hours and minutes are not the same as the phone shows and I think it is due to the time zone
Is there any way?
Hello,
NOW(SET_TIMEZONE(NOW(“”), “America/Sao_Paulo”))
Works for me, returning the current date/time with adjusted timezone
You need to change “America/Sao_Paulo” for your needs
Thank you! It worked but it shows like the whole thing
I need to hot it like this “DD/MM/YY HH:MM” not the timezone.
Is it possible?
I think you can use
FORMAT_DATETIME_LOCAL(SET_TIMEZONE(NOW(“”), “America/Sao_Paulo”), “DD/MM/YYYY HH:MM”)
It worked! Thank you