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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Format problem - removing leading 0

My dates come into qlikview as 06/09/2011 but the data in the CSV is 6/9/2011. I want my dates to use the CSV format of 6/9/2011. I used

M/D/YYY in my date#() function and still the leading zero shows up in qlikview.

2 Replies
Not applicable
Author

Try Date() instead of Date#()

Not applicable
Author

Hi debbiepy ,

Try like this..

Date(DateFieldName,'M/D/YYYY')