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?