Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chesterluck
Contributor II

How to change a format from timestamp to date

Hello community

I had several problems while cleansing my time fields.

The solution which worked was:

 

Timestamp(alt(num#(Schichtdatum,'#','.',','),Timestamp#(Schichtdatum, 'DD.MM.YYYY hh:mm:ss')))) as Schichtdatum

In the last step I then created a calender. That worked in the end also fine.

But when linking my CalDate field with the field from the formula upstaires (Schichtdatum) it happend what should have happened.

My CalDate (20.12.2012) was only linked to Schichtdatum (20.12.2012 00:00:00 (and not to 20.12.2012 14:00:23 aso)).

I tried to put Date() around the formula - and voila the Date was shown in the listfield - but unfortunately the format is still timestamp.

So.. should I try with date#() or sth like makedate() functions or any other ideas?

Thx in advance

//chesterluck

1 Reply
rajni_batra
Valued Contributor

Re: How to change a format from timestamp to date

Try with Date(Floor())

Community Browser