Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Date format

I have attached date format...How to convert that to regular date ?

4 Replies
adityaakshaya
Creator III
Creator III

Hi Ansh,

Lets say we have a date field EgDate.

Date( Floor( Timestamp#( EgDate, 'YYYY-MM-DD hh:mm:ss')), 'M/D/YYYY') as ModifiedDate.

Regards,

Akshaya

MarcoWedel

There are two formats in your screenshot.

Which one is your source format?

MarcoWedel

Besides your source format, one solution to convert a timestamp into a date is the Dayname() function.

hope this helps

regards

Marco

sasiparupudi1
Master III
Master III

Use Date(Floor(Date),'YYYY-MM-DD')