Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Is there a "null date"? So I don't get errors or "Your result type is not a number or a date."

Topic Labels: Formulas
Solved
Jump to Solution
3491 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan
6 - Interface Innovator
6 - Interface Innovator

For example, I have a date field, some of which are filled in, some of which are not. I want to make a second date field that is a time offset from the first. I want this formula field to stay in date format so it can be exported to a calendar, etc:

image

However, when the first field is blank, the second field shows an error instead:

image

How can I change my formula to output “absence of date” when the first field is blank? Using IF(BLANK( to return "" or 0 breaks the date formatting:

image

1 Solution

Accepted Solutions
Jonathan
6 - Interface Innovator
6 - Interface Innovator

Just leaving the “else” argument blank seems to work:

IF({date}, something)

See Solution in Thread

3 Replies 3

Hi @Jonathan
You are on the right track!

The format for an IF formula is IF(something that can be true, do this if true, do this if false)

IF({date}, something, '')

So IF(there is a date in the field named date, do something, otherwise output blank)

That doesn’t work, as I said. "" is a string, not a date, so the field cannot be formatted as a date anymore:

image

Jonathan
6 - Interface Innovator
6 - Interface Innovator

Just leaving the “else” argument blank seems to work:

IF({date}, something)