topic Re: How To Convert Date into DateShort in QlikView

How To Convert Date into DateShort

Fri, 10 May 2013 16:36:16 GMT

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.

Re: How To Convert Date into DateShort

Gysbert_Wassenaar — Fri, 10 May 2013 16:42:53 GMT

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.

Re: How To Convert Date into DateShort

rustyfishbones — Fri, 10 May 2013 16:43:37 GMT

try

Regards

Alan

Re: How To Convert Date into DateShort

Fri, 10 May 2013 19:23:03 GMT

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

Thanks,

Sujith.

Re: How To Convert Date into DateShort

rustyfishbones — Fri, 10 May 2013 20:00:00 GMT

You could try this