topic Re: Convert date and Time to required format in QlikView

Convert date and Time to required format

Anonymous — Thu, 21 Jul 2016 07:22:26 GMT

1/5/2013/16/23

1- day

5 - month

2013 - year

16 - 24 hr time

23 - minutes.

This is the date and time format i have, where i need it like below:

1/5/2013 16:23

Thanks..

kaushiknsolanki — Thu, 21 Jul 2016 07:25:45 GMT

Hi,

Use the Timestamp(Date , 'MM/DD/YYYY hh:mm')

Regards,

Kaushik Solanki

Anonymous — Thu, 21 Jul 2016 07:31:12 GMT

Its not working.. am getting empty list...

kaushiknsolanki — Thu, 21 Jul 2016 07:32:52 GMT

Can you Post sample QVW file.

Regards,

Kaushik Solanki

Digvijay_Singh — Thu, 21 Jul 2016 07:34:45 GMT

Try this -

=Timestamp(Timestamp#('1/5/2013/16/23','DD/MM/YYYY/hh/mm'),'DD/MM/YYYY hh:mm')

er_mohit — Thu, 21 Jul 2016 07:35:51 GMT

Try this in text object

= timestamp(Timestamp#('1/5/2013/16/23','D/M/YYYY/hh/mm'),'DD/MM/YYYY hh:mm')

MindaugasBacius — Thu, 21 Jul 2016 07:42:29 GMT

Try like this:

=Timestamp(Timestamp#('1/5/2013/16/23','DD/MM/YYYY/hh/mm'),'DD/MM/YYYY hh:mm')

The output:

The idea. Firstly you need the interpretation function that ends with #. Secondly you have to define date and time format.

Thu, 21 Jul 2016 07:43:27 GMT

Hi Kishore,

Try this

Timestamp(Timestamp#(date1,'DD/MM/YYYY/hh/mm'),'DD/MM/YYYY hh:mm')

Regards

Bazil Momin