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: 
Not applicable

converting timestamp

Please help in converting the timestamp in below fornmat to MM/DD/YYYY hh:mm:ss

Wed Aug  9 06:00:00 2017 - 08/09/2017 06:00:00

9 Replies
Anonymous
Not applicable
Author

Hi,

Try Date(Field, 'MM/DD/YYYY hh:mm:ss')

ahaahaaha
Partner - Master
Partner - Master

Hi,

Try

=TimeStamp(TimeStamp#(SubField('Wed Aug  9 06:00:00 2017 - 08/09/2017 06:00:00', '- ', 2), 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY hh:mm:ss')

sasiparupudi1
Master III
Master III

Timestamp(Timestamp#(Subfield('Wed Aug  9 06:00:00 2017 - 08/09/2017 06:00:00','-',2),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

Not applicable
Author

Hi Binod,

U might have got the answer if u have seen above replies. Anyways. Try this.

Timestamp(Timestamp#(Subfield('Wed Aug  9 06:00:00 2017 - 08/09/2017 06:00:00','-',2),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Binod,

Please Try Below:

Try

=Date(TimeStamp#(SubField('Wed Aug  9 06:00:00 2017 - 08/09/2017 06:00:00', '- ', 2), 'MM/DD/YYYY hh:mm:ss'), 'MM/DD/YYYY ')


Thanks,

Arvind Patil

Not applicable
Author

Try this it will work

=date(date#(Mid('Wed Aug 9 06:00:00 2017',5),'MMM DD hh:mm:ss YYYY'),'MM/DD/YYYY hh:mm:ss')

Not applicable
Author

Hi All,

Sorry for the confusion

Please help in converting the timestamp in below fornmat to MM/DD/YYYY hh:mm:ss

This is the input format - Wed Aug  9 06:00:00 2017

Expected Output - 08/09/2017 06:00:00

sasiparupudi1
Master III
Master III

=TimeStamp(TimeStamp#(Mid('Wed Aug 9 06:00:00 2017',Index('Wed Aug 9 06:00:00 2017',' ')+1),'MMM D hh:mm:ss YYYY'),'MM/DD/YYYY hh:mm:ss')

hth

Sasi

sasiparupudi1
Master III
Master III

Hi Vinod

Have you come alright with your problem?

Sasi