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:
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()
)
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()
)
That worked! Thanks so much.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.