Formulas not detecting the forward Slash in a V_String Date Field.

[rgusaas]

I am appending daily files together into a single stack and am having a problem formatting a V_String formatted Date/Time field.  The data in the string field comes in two formats:

1/12/2017 1:00:08 PM

AND

2017-01-12 13:00:08

I have a multi-field tool that first strips off the time using a simple GetWord function.

Next, I have written a formula to parse the year, month, day for only the records with the forward slash (/) again using the multi-field tool. The date/time tool will format the first example but returns a null value for the second format.

I have tried several formulas to detect the forward slash and none work.

Example attached.

Suggestions?

Thanks in advance.

Contains("/", [New_PROCESSTIME]) returns all false

IIF(FindString("/", [PROCESSTIME]) >0, "true","false")

[patrick_digan · Accepted solution]

@rgusaas Try flipping the order of your formula:

Contains([New_PROCESSTIME],"/")

[rgusaas]

I am embarrassed.

Thank you for your time.