Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
soniasweety
Master
Master
Author

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
Champion
Champion

take a look at Michael solomovich on this thread:

Convert local time to GMT

soniasweety
Master
Master
Author

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

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
Champion
Champion

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

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

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

Use &' '&expression 

Make space in beetween single quotes

soniasweety
Master
Master
Author

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'