topic Re: converting timestamp in QlikView

converting timestamp

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: converting timestamp

Anonymous — Fri, 11 Aug 2017 07:10:42 GMT

Hi,

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

Re: converting timestamp

ahaahaaha — Fri, 11 Aug 2017 07:17:00 GMT

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

Re: converting timestamp

sasiparupudi1 — Fri, 11 Aug 2017 07:22:57 GMT

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

Re: converting timestamp

Fri, 11 Aug 2017 08:43:07 GMT

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

Re: converting timestamp

arvind_patil — Fri, 11 Aug 2017 08:54:57 GMT

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

Re: converting timestamp

Fri, 11 Aug 2017 09:16:08 GMT

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

Re: converting timestamp

Fri, 11 Aug 2017 13:04:12 GMT

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

Re: converting timestamp

sasiparupudi1 — Fri, 11 Aug 2017 18:40:31 GMT

=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

Re: converting timestamp

sasiparupudi1 — Wed, 16 Aug 2017 06:37:24 GMT

Hi Vinod

Have you come alright with your problem?

Sasi