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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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')