Error for Date Field when not filled out

[queasha10]

I have a field that shows the week of the year, but I break my records up sometimes by leaving some fields blank. How can I get rid of the #ERROR! message that is shown whenever there is no date (or week) in that field?

Here is the formula I use: 

DATETIME_FORMAT({Date to be Posted},"w")

[Jack_Manuel · Accepted solution]

You can wrap your formula in an IF() that checks if Date to be Posted exists, returns your formula if it does and returns blank if it doesn't.

IF(
  {Date to be Posted},
  DATETIME_FORMAT({Date to be Posted},"w"),
  BLANK()
)

[queasha10]

That worked! Thanks so much.