to_date conversion returning NULL as the result
I used the following formula to convert an int field to a date :
to_date ( fiscal year begin date , '%y%m%d')
"fiscal year begin date" has values like 20161225 (yyyymmdd)
The formula returns "NULL" (see screenshot) and I'm sure I'm missing something obvious.. thanks in advance for all the help!