topic Re: Date format in QlikView

Date format

Thu, 05 Mar 2015 09:54:34 GMT

Hi Every one,

I have issue with date format.

In list box I have to show date but it showing like - 201412, when I make it to date(reporting-date) then its looks like - 6/11/2451 show how to change it to normal.

Thank you

Re: Date format

robert_mika — Thu, 05 Mar 2015 09:57:11 GMT

Here is post with similar issue and how to solve it

date format

Look at my last response and use these expression:

Re: Date format

avinashelite — Thu, 05 Mar 2015 09:58:22 GMT

Hi Raj,

In which format the date is saved??

try with date or date# function this should do. If your still facing any issues please provide the sample data so that we can work on that.

Re: Date format

maleksafa — Thu, 05 Mar 2015 09:58:47 GMT

first option is to change the date format in the load script, in the first page

SET DateFormat='DD/MM/YYYY';

or when loading the date field you can change the format uising the Date() function date(expression [ , format-code ])

Re: Date format

luciancotea — Thu, 05 Mar 2015 10:01:27 GMT

You have the date loaded as integer (201412). You need to load it (in the script) as date. Depending on the way you have you data stored, use date#() or makedate() functions to transform string or integer into date.

Note: date() is a formatting function, not a transformation one.

Re: Date format

Thu, 05 Mar 2015 10:05:34 GMT

Date is stored in 201412, so how can I change it to 31/12/2014.

Re: Date format

jagan — Thu, 05 Mar 2015 10:08:38 GMT

Hi,

Try like this

MonthEnd(Date#('201412', 'YYYYMM'))

MonthEnd(Date#(DateFieldName, 'YYYYMM'))

Hope this helps you.

Regards,

Jagan.