Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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?

Tags (1)
18 Replies
Highlighted

Re: Format

May be this

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

Highlighted
Partner
Partner

Re: Format

Try this

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

Highlighted
Specialist III
Specialist III

Re: Format

thanks sunny,

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

Highlighted

Re: Format

Use ConvertToLocalTime() function

Re: Time Zone Conversation

Highlighted
Partner
Partner

Re: Format

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

Highlighted
Specialist III
Specialist III

Re: Format

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

Highlighted
Specialist III
Specialist III

Re: Format

Highlighted
Partner
Partner

Re: Format

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

];

Highlighted
Partner
Partner

Re: Format

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