Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

"IF" statement for Dates

Topic Labels: Formulas
Solved
Jump to Solution
331 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there! I’m fairly new to formulas and have been playing around with using them in a new base for a client.

I’m wondering if there is any way to create an IF statement or some other formula for if a Date field is empty? Right now if the date field is marked empty, it showcases an error, but I’d like it to still include the other values if left blank. It would be great if it could maybe have TBD" instead.

Any suggestions are greatly appreciated!

Here’s the formula I have so far:

"[" & DATETIME_FORMAT({START / LIVE DATE}, ‘MM/DD’) & "] " & {PROJECT / PROMO NAME} & " " & “[” & SEASON & "]"

Also a screenshot of what I’m trying to do: Screen Shot 2021-02-11 at 11.28.52 AM

1 Solution

Accepted Solutions

Thank you all for your assistance! I was finally able to rework this by having a field designated only to the IF statement for the date and have the primary field formula reference that.

See Solution in Thread

4 Replies 4

IF({My Date Field}=BLANK(), . . .
Should do it.

Thank you! I was able to make that formula work as a stand-alone, but am still having trouble figuring out how it should fit into my existing formula. When I try to embed it into the date portion it works as a formula but still doesn’t act as it should and I’m still receiving errors :confused:

See if this works.

“[” & IF({START / LIVE DATE},DATETIME_FORMAT({START / LIVE DATE}, ‘MM/DD’)) & "] " & {PROJECT / PROMO NAME} & " " & “[” & SEASON & “]”

Thank you all for your assistance! I was finally able to rework this by having a field designated only to the IF statement for the date and have the primary field formula reference that.