Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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')