topic Re: Convert Date Format in QlikView

Convert Date Format

rupaliqlik — Wed, 31 Aug 2016 10:10:00 GMT

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 — Wed, 31 Aug 2016 11:53:51 GMT

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

arulsettu — Wed, 31 Aug 2016 11:59:34 GMT

you can try this

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

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

Chanty4u — Wed, 31 Aug 2016 12:00:10 GMT

try below

Format:

LOAD * INLINE [

dateformat

20160705

];

Result:

LOAD *,

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

Resident Format;

Anonymous — Wed, 31 Aug 2016 12:04:13 GMT

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!!

AnusuyaRajavel — Tue, 22 Oct 2024 05:56:38 GMT

try below:

you can use date function : load Date(fieldname) from filename;