GMT Conversion - Formula

HCL Domino Domino Forum
1

Hi Lotus Gurus,

Is there any way to convert given datetime value to GMT using formula language?

In lotus script GMTTime property converts given datetime to GMT.

Any help is highly appreciated.

Thanks, & Regards

P. Mallik Ram Sharma

2

Subject: GMT Conversion - Formula

@Zone tells you how many hours need to be added to convert to GMT, so you could use that in an @Adjust statement, i.e.,

@Adjust( ActualDate; 0; 0; 0; @Zone( @Now ); 0; 0 )

3

Subject: RE: GMT Conversion - Formula

Thanks Martha,

In fact we tried the way suggested by you in the past. However, it was in a different method

temp1 := “01/21/2014 02:46:45 AM ZE8”;

temp2 := @Zone(@TextToTime(temp1));

temp3 := @Adjust(@TextToTime(temp1);0;0;0;temp2;0;0);

We will try the way suggested by you.

Many Thanks for your reply.

Thanks & Regards,

P. Mallik Ram Sharma