This content has been marked as final. Show 2 replies
I am having problems formatting a date while loading. No errors, but Qlikview doesn't format it correctly.
I am reading dates from an Excel spreadsheet. All dates in that Excel document are in YYYY-MM-DD format.
When I am loading my qv document I want to change all dates after October 31 2011 to October 31 2011.
In my script it looks like this:
Date(if(date_to>'2011-10-31',date_to='2011-10-31',date_to)) as date_to
Qlikview changes all matching dates to 1899-12-30.
Why...what am I doing wrong?