Discussion board where members can get started with QlikView.
I'm trying to load month/year format as datetime, so '01/2012' would become 01/01/2012 datetime.
However I don't quite understand why the following doesn't work
Date(MonthYear, 'MM/YYYY') as MyDate
INLINE [Amount, MonthYear
I also trie the following
Date('01/' & MonthYear, 'DD/MM/YYYY') as MyDate
But that didn't work either.
What could be wrong with my load script?
Go to Solution.
Date(Date#(MonthYear, 'MM/YYYY')) as MyDate
Or, if you want to be more explicit:
MonthStart(Date#(MonthYear, 'MM/YYYY')) as MyDate
The Date() function formats the display format of a date. The Date#() function interprets a string value as a date.
Hope that helps