Hi.. How to convert datetime from GMT to user's local timestamp? i.e 25/06/2

Sharmila Nagaraj

A Score Level 1

over 9 years ago

Hi.. How to convert datetime from GMT to user's local timestamp? i.e 25/06/2015 01:00 GMT+01:00 has to be displayed as 25/06/2015 01:00

Discussion posts and replies are publicly visible

Parents

0 davidm415 over 9 years ago

There are probably a number of ways to do this, but I was able to get something similar to what you are looking for by doing:
datevalue(pv!dateTime)&" "&time(pv!dateTime)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 davidm415 over 9 years ago

There are probably a number of ways to do this, but I was able to get something similar to what you are looking for by doing:
datevalue(pv!dateTime)&" "&time(pv!dateTime)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data