topic Re: Date & time format in QlikView

Date & time format

daniel_f — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

can someone please advise what the best way to convert the format date time: "20170807121648" to date and time in order to later find the max\maxstring?

thanks in advance,

Daniel

Re: Date & time format

kaushiknsolanki — Thu, 10 Aug 2017 10:23:04 GMT

Try Timestamp#() function

Regards,

Kaushik Solanki

Re: Date & time format

jmvilaplanap — Thu, 10 Aug 2017 10:28:17 GMT

Hi,

You have to convert it to date, you can use the Date# function

Date#(yourDateField, 'YYYYMMDDhhmmss')

Regards

Re: Date & time format

vishsaggi — Fri, 18 Aug 2017 00:29:44 GMT

Try this?

= Date(Date#('20170807121648', 'YYYYDDMMhhmmss'), 'MM/DD/YYYY hh:mm:ss')

Re: Date & time format

Fri, 18 Aug 2017 05:15:32 GMT

Try this working fine....

Timestamp(Date#('20170807121648', 'YYYYDDMMhhmmss'))

Re: Date & time format

its_anandrjs — Fri, 18 Aug 2017 05:56:29 GMT

You can use Makedate() or Timestamp() functions for the same.

Regards,

Anand