Conditional Date Time statement not working

[VeronicaElse]

Hi, 

I have about a couple of records that should be NOT MET but they are ALL showing MET.

I have done a DATETIMEPARSE and still not working. Also, I would like to add something that will detect a blank date as also NOT MET. 

IF DateTimeParse([Deadline Date],'m%/%d/%Y %I:%M %p ' )< DateTimeParse([Completed Date],'m%/%d/%Y %I:%M %p ' ) THEN "MET" ELSE "NOT MET" ENDIF

Deadline Date         Completed Date

8/12/2022 4:30 PM    8/12/2022 4:45 PM
8/12/2022 4:30 PM    8/12/2022 4:38 PM
8/12/2022 12:00 PM  8/12/2022 11:45 AM
null                             8/10/2022 4:49 PM

Please HELP

thanks

[OllieClarke · Accepted solution]

@VeronicaElse I think you've a typo - should be '%m' not 'm%' at the start
Something like:

If ISNULL([Deadline Date]) THEN 'NOT MET'
ELSEIF DATETIMEPARSE([Deadline Date],'%m/%d/%Y %I:%M: %p') < DATETIMEPARSE([Completed Date Date],'%m/%d/%Y %I:%M: %p') THEN 'MET'
ELSE 'NOT MET'
ENDIF

Hope that helps,

Ollie

[IraWatt · Accepted solution]

Hey @VeronicaElse,

Looks like your formula is good, just got the %m in the datetimeparse the wrong way round, should be:

IF DateTimeParse([Deadline Date],'%m/%d/%Y %I:%M %p' )< DateTimeParse([Completed Date],'%m/%d/%y %I:%M %p ' ) THEN "MET" ELSE "NOT MET" ENDIF

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com