Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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