Converting GMT to UTC-4 TimeStamp

[#1]

Hello,

How can I convert the TimeStamp from GMT to UTC-4?

For example, I have the data field call "submitted date" which is GMT time. How can I convert it to local time UTC-4?

Also, if I want to get the month after converted the time. What will be the full command line looks like?

Thanks,

Becky

[iahamedabdullah]

Hi Give a try,

1. To get UTC-4 use this Expression: Timestamp(submitted date-Time#(4,'hh'))

2. To get Month after conversion: Month(Timestamp(submitted date-Time#(4,'hh')))

[rbecher]

Hi Yun,

you can use:

=ConvertToLocalTime(<YourTimeField>, 'GMT-04:00')

- Ralf

[#4]

Thanks Ralf.

Is your way suppose to use in script when load date, or use in expression?
I used the way in Expression. It shows error. Where should I  change?

[#5]

Thanks! It works.

One more question, I can use this in expression right? Or I can use this both in script and expression?

[rbecher · Accepted solution]

‌Just use your fieldname. <  > was a placeholder..

Btw, this is the only function taking care of daylight saving in target time zone. So, first example subtracting 4 hrs might not work in all situations.

[#7]

Thanks Ralf.

Is there a way that we can do with the daylight saving? Or we have to manually change the expression?

[rbecher]

ConvertToLocalTime() does it automatically..

[#9]

Oh, thanks. I think I got confused from your previous comments. I thought the ConverToLocalTime() won't work for day light saving...

So for those country they don't have daylight saving, shall I use "Timestamp(Date - Time#(4,'hh'))"?

[rbecher]

It should work also for places having no daylight savings but I'm not sure if the parameter is not a place but a GMT value. I think it would be probably better to use places (see help).