Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
thabang_petje
Partner
Partner

Hi,

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

ahaahaaha
Master
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
Partner

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