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

formatting dates

Hi, I have an If statement in my Dimension Expresion box to limit my date dimension to 18 months.

=Date(If(PeriodDate > MonthStart(Today(),-18), PeriodDate, Null()), 'MMM/YYY')

It works in limiting my chart to 18 months but now the dates show as numbers ( 40600 etc ).  How can I get these to show as dates.  The load statements loads the dates as MM/YYYY.    Thanks, Jim

10 Replies
Not applicable
Author

Thanks everyone for all of your help!!!