Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Format

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?

18 Replies
sunny_talwar

May be this

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

vishweshwarisun
Partner - Creator
Partner - Creator

Try this

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

soniasweety
Master
Master
Author

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
Partner - Creator II
Partner - Creator II

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

soniasweety
Master
Master
Author

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
Master
Master
Author

vishalarote
Partner - Creator II
Partner - Creator II

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
Partner - Creator II
Partner - Creator II

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')