Solved: Convert date and Time to required format - Qlik Community

Anonymous · ‎2016-07-21

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..

MindaugasBacius · ‎2016-07-21

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.

kaushiknsolanki · ‎2016-07-21

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2016-07-21

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

kaushiknsolanki · ‎2016-07-21

Can you Post sample QVW file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Digvijay_Singh · ‎2016-07-21

Try this -

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

er_mohit · ‎2016-07-21

Hi

Try this in text object

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

MindaugasBacius · ‎2016-07-21

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.

Report Inappropriate Content · ‎2016-07-21

Hi Kishore,

Try this

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

Regards

Bazil Momin