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