Coverttolocaltime

[#1]

Hi All,

I am trying to convert the format 29/08/2015 03:05:37 to time only but the problem is that I need to add 4 hours to it so that it reflect GMT+04:00.

So my answer should be 07:05:37.

My current line i my loading script is as below:

Time(Frac([createdtime]), 'hh:mm:ss') as Time,

Kind Regards,

Hasvine

[Anonymous · Accepted solution]

Something like :

     Time(Frac([createdtime]) + (4/24) , 'hh:mm:ss') as Time,

[MK_QSL]

=Time(Frac(TimeStamp#('29/08/2015 03:05:37','DD/MM/YYYY hh:mm:ss')) + Time#('4','h'))

[Anonymous]

see this:

how to convert a local time to utc time when I have the time zone?

Convert local time to GMT

How to convert from local time?

May be helpful to you!!

[#5]

Thank you all.

KR,

Hasvine