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?

[sunny_talwar]

May be this

Timestamp(Max(RecordModifiedDate),'DD-MMM-YY h:mm TT') & ' EST'

[vishweshwarisun]

Try this

Timestamp(Max(RecordModifiedDate),'DD-MMM-YY hh:mm TT')&'EST'

[soniasweety]

thanks sunny,

my timestamp is in IST but I need to convert this to EST       your expression  will not work for me I think

[sunny_talwar]

Use ConvertToLocalTime() function

Re: Time Zone Conversation

[vishalarote]

Timestamp(Timestamp#(Max(RecordModifiedDate),'MMM DD  YYYY hh:mm:ss'),'DD-MMM-YY h:mm TT') &'EST'

[soniasweety]

no I need to convert the ist to est

it means  now  6:00 pm ist  means I need to show  8:30 Am

https://www.worldtimebuddy.com/ist-to-est-converter

[soniasweety]

youssef belloum

[vishalarote]

Ok Try this

t1:

load

Timestamp(Timestamp#(Date,'MMM DD YYYY hh:mm:ss'),'DD-MMM-YY  h:mm TT') &' '&'EST' as NewDate

inline [

Date

Apr 21 2018 19:24:56

Mar 21 2018 14:23:45

];

[vishalarote]

if you want max also then i am trying this in front end

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