Parse a date if exists, otherwise blank

[Emily_McLain]

Hello! I'm sure there is a very easy solution for this but I am having trouble figuring it out! 

I have an "Ad Record" field that may or may not have a date at the start (ex. "1/2/23 | Company | Product"). This formula parses out the date for me easily enough:

DATETIME_PARSE({Ad Record},'MM/DD/YYYY')

However, sometimes there may not be a date (ex. "Company+") so the above formula parses an ERROR. What sort of IF statement would work here to instead leave the field empty?

This didn't work for me:

IF({Ad Record}, DATETIME_PARSE({Ad Record},'MM/DD/YYYY'), "")

Thank you! 

[TheTimeSavingCo · Accepted solution]

Could you try the following?

IF(
  ISERROR(DATETIME_PARSE({Ad Record},'MM/DD/YYYY')) != 1,
  DATETIME_PARSE({Ad Record},'MM/DD/YYYY')
)

[Emily_McLain]

That worked! I knew it would be something simple.

Thank you so much!