Convert Date Format

[rupaliqlik]

Hi Experts,

I want to change format of my Date.It is now in Num format,but I wants to change it into DD/MM/YYYY. How do I get.

[oknotsen]

Use the date() function (not to be mistaken by the date#() function).

Date ‒ QlikView

[arulsettu]

you can try this

date(datefield,'DD/MM/YYYY')

or

date(date#(datefield,'current format'),'DD/MM/YYYY')

[Chanty4u]

try below

Format:

LOAD * INLINE [

    dateformat

    20160705

];

Result:

LOAD *,

Date(Date#(dateformat,'YYYYMMDD'),'MM-DD-YYYY') AS Newdate

Resident Format;

[Anonymous]

Hi Rupali,

If you want to change all dateformats and timestamp formats on your app, change this variables on script:

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';

If you enter the date as a number, you will see ever a number, then, when on script get the field use this expression:

Date(YourField) as YourField

Regards!!