Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

date issue format

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;

4 Replies
sunny_talwar

May be try like this:

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

Kushal_Chawda

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

Chanty4u
MVP
MVP

try

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

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

Not applicable

 

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