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!

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
reply to topic
Like Follow
  • Status Answered
  • 9 mths agoLast active
  • 2Replies
  • 362Views
  • 2 Following