Help

Re: DATETIME_FORMAT return as "Pending" instead of #ERROR!?

Solved
Jump to Solution
563 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shawntel_Cote
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi! I’ve been using the below formula for awhile, but it returns an #ERROR! for the fields where {FOC (Current)} is blank. For cleaner reporting I’d like to have it return as “PENDING” but can’t seem to get an IF formula to work successfully. Any suggestions?

DATETIME_FORMAT({FOC (Current)},‘YYYY, MM (MMMM)’)

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Here you go:

IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Here you go:

IF({FOC (Current)},DATETIME_FORMAT({FOC (Current)},'YYYY, MM (MMMM)'),"PENDING")

Worked perfectly! thank you