topic date issue format in QlikView

date issue format

manoranjan_d — Fri, 13 May 2016 08:41:14 GMT

Hi Previously i have the date format with MM-DD-YYYY and now currently i have changed the without -, below is the sample but the result showing as with -,

date(created_date,'MMDDYYYY') as created_date;

Re: date issue format

sunny_talwar — Fri, 13 May 2016 08:43:00 GMT

May be try like this:

Date(Date#(created_date, 'MM-DD-YYYY'), 'MMDDYYYY') as created_date

Re: date issue format

Kushal_Chawda — Fri, 13 May 2016 08:46:20 GMT

date(date#(created_date,'MMDDYYYY'),'MM-DD-YYYY') as created_date;

Re: date issue format

Chanty4u — Fri, 13 May 2016 08:55:32 GMT

try

Date(Date#(created_date,'MMDDYYYY'),'MM-DD-YYYY') as created_date;

Date(Date#(created_date,'MMDDYYYY'),'Dateformat') as created_date;

Re: date issue format

Mon, 16 May 2016 11:02:35 GMT

hello manoranjan you can try this Date(Date#(created_date, 'MM-DD-YYYY'), 'MMDDYYYY') as created_date and I am agree

with sunny T but it can"t be helpful for you https://goo.gl/fJU04Btry this also may be this stuff work for you