topic How to change the date format in QV? in QlikView

How to change the date format in QV?

Mon, 21 Nov 2011 14:17:22 GMT

I've a table from which a date value is fetched in the format 'mm/dd/yyyy'. I've stored this value in a variable and want to change the format to 'yyyy-mm-dd' to pass it to some other SQL.

Please help.

Re: How to change the date format in QV?

Mon, 21 Nov 2011 14:19:23 GMT

Try this:

Date(date,'YYYY-MM-DD')

How to change the date format in QV?

Mon, 21 Nov 2011 14:20:46 GMT

You can use date# function

Re: How to change the date format in QV?

Mon, 14 Jan 2013 04:47:51 GMT

Try:

Date(Date#([your date field]),'YYYY-MM-DD')

Regards

Re: How to change the date format in QV?

nirav_bhimani — Mon, 14 Jan 2013 06:20:33 GMT

Hi,

One more alternative is Go to...........

Setting-> Document Property ->Number->Select Filed->Select Number format setting = Date ->apply your Format pattern like 'YYYY-MM-DD'.

Regards,

Nirav Bhimani