Malformed Call Function in formula tool

Hi everyone,

I'm getting an error in this formula tool within an IF statement and I'm not sure what's needed to correct the expression. Any ideas?

IF Contains([Join Time],'PM' OR 'AM')
THEN [Join Time]
ELSE DateTimeParse([Join Time],"%m/%d/%Y %k",)
ENDIF

Workflow

Error Message

Parse

Date Time

Accepted answers

ed_hayter

@kceesay try this

It parses the date times without AM, PM then wrapped in a datetimeformat to return a string with the same date structure as you already have in your data

solve.yxzp

All comments

Prometheus

@kceesay Can you show an example of what your data looks like coming into the Formula tool?

ed_hayter

Splitting your test clause might help:

IF Contains([Join Time], "PM") OR Contains([Join Time], "AM") THEN ...

kceesay

@Prometheus The column contains data like the below. I want to standardize the formatting.

08/29/2023 03:02:51 PM
08/29/2023 03:15:20 PM
08/29/2023 03:46:57 PM
8/17/2023 9:45
8/17/2023 9:54
8/17/2023 9:54

@ed_hayter I tried breaking it up, but I think the issue may be in another part of the expression. I've attached a screenshot.

Screenshot 2023-09-08 105839.png

ed_hayter

@kceesay try this

It parses the date times without AM, PM then wrapped in a datetimeformat to return a string with the same date structure as you already have in your data

solve.yxzp

Deano478

@kceesay you can give this a try:

IF Contains([Join Time], 'PM') OR Contains([Join Time], 'AM')
THEN [Join Time]
ELSE DateTimeParse([Join Time], "%m/%d/%Y %H:%M")
ENDIF

kceesay

@ed_hayter That worked thank you so much!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335