Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Format

Hey,

I'm having a little bit of an issue with the format of dates.

Dates are being Imported in the format 20120101 000000, So YYYYMMDD HHMMSS

However I would like it to just display as YYYY-MM-DD

Is there any way of doing this??

Thanks in advance!

Natalie

2 Replies
Not applicable
Author

HI

DATE(DATE#('20120101 000000','YYYYMMDD hhmmss'),'YYYY-MM-DD')

manideep78
Partner - Specialist
Partner - Specialist

Try with vishwaranjan code. Its absolutely fine.

Also refer the attached link for more knowledge on date and time format

Why don’t my dates work?