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: 
gerrycastellino
Creator III
Creator III

using the date#() function

Hi team:

Trying to change my date format from 

"03 - March, 2021"

to a standard date format as MM/DD/YYYY.

How would I use the date#() function for this ?

 

G.

 

Labels (2)
1 Reply
rbartley
Specialist II
Specialist II

Hi,

Date(Date#(UnformattedDate,'DD - MMMM, YYYY'),'MM/DD/YYYY')

You can use this in the load script or in your charts.

Date#1.PNG

Date#2.PNG