How To Convert Date into DateShort

[#1]

Hi,

I have a date column coming out of a SQL table  which has the values like '2012-01-29 00:00:00.000' but i want to bring back only the '20120129' out of it and use it as a field in Qlikview Document  .Can someone help me with how to get around this one?

Thanks,

Sujith.

[Gysbert_Wassenaar · Accepted solution]

Just change the display format: date(MyDate,'YYYYMMDD'). If the dates have a time part then you can use date(floor(MyDate),'YYYYMMDD') to cut of the time part.

[rustyfishbones]

try

Regards

Alan

[#4]

From the above question,if i want to bring the hour format only excluding the date.How can i do that?

Thanks,

Sujith.

[rustyfishbones]

You could try this