Skip to main content
Solved

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

Shawntel_Cote
Forum|alt.badge.img+5

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

Best answer by ScottWorld

Here you go:

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

View original
This topic has been closed for replies.

2 replies

ScottWorld
Forum|alt.badge.img+35

Here you go:

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

    Shawntel_Cote
    Forum|alt.badge.img+5

    Here you go:

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


    Worked perfectly! thank you

      Terms & ConditionsAccessibility statement