Help

Error for Date Field when not filled out

Topic Labels: Formulas
Solved
Jump to Solution
1111 2
cancel
Showing results for 
Search instead for 
Did you mean: 
queasha10
4 - Data Explorer
4 - Data Explorer

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")
1 Solution

Accepted Solutions
Jack_Manuel
7 - App Architect
7 - App Architect

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()
)

  

See Solution in Thread

2 Replies 2
Jack_Manuel
7 - App Architect
7 - App Architect

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.