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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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