Format

[soniasweety]

Hi all,

I have date field     am using like this now

Timestamp(Max(RecordModifiedDate),'MMM DD  YYYY hh:mm:ss')

result am getting  Apr 21 2018 19:56:28

so I want to be displayed like below format

21-Apr-18 4:47 PM EST

how to achieve this?

[soniasweety]

No vishal

I want to convert local time to USA EST tme zone

for your code it will add the est at end of timestamp only

[YoussefBelloum]

take a look at Michael solomovich on this thread:

Convert local time to GMT

[soniasweety]

am able to get now but  timestamp format I m unable to achieve how to do

ConvertToLocalTime(timestamp(max(RecordModifiedDate),'DD-MMM-YY h:mm TT'),'GMT-09:30')&' EST'

this format not working 'DD-MMM-YY h:mm TT'

[vishalarote]

Try this it will work

=Timestamp(ConvertToLocalTime(Max(Timestamp(Timestamp#(Date,'MMM DD YYYY hh:mm:ss'),'DD-MMM-YY  h:mm TT'))),'DD-MMM-YY  h:mm TT')

[YoussefBelloum]

are trying to convert your local time into EST time or you're trying to convert EST time to your local indian time ??

1. convert UTC/GMT to localtime:

converttolocaltime() like Sunny suggested on the above thread attached

2. convert localtime to GMT:

GMT() function like describe on the thread that I attached above.

[soniasweety]

nice its working in local need to chk

but one thing  am getting result without space between AMEST    but  I need  AM  EST     for space which chr()  function I need to use?

[sasiparupudi1]

May be try

=Timestamp(ConvertToLocalTime(Timestamp#('Apr 21 2018 19:56:28','MMM DD YYYY hh:mm:ss'),'Eastern Time (US & Canada)'),'DD-MMM-YY h:mm TT') & ' EST'

[vishalarote]

Use &' '&expression 

Make space in beetween single quotes

[soniasweety]

but as per  this date the output should be  10:00 AMEST  but am getting the result  3:56 PM EST

Vishal Arote

how to get the exact ?

this used =Timestamp(ConvertToLocalTime(Timestamp#('Apr 21 2018 19:56:28','MMM DD YYYY hh:mm:ss'),'Eastern Time (US & Canada)'),'DD-MMM-YY h:mm TT') & ' EST'