AnsweredAssumed Answered

Regular Expression to remove time after the year of the date

Question asked by casey on Sep 25, 2018
Latest reply on Oct 12, 2018 by sharon_tamang

 I have  Run If action I am trying to use, but the 2 dates I'm comparing are showing the time after them as well. 

 

Using the Log History action, I found my 2 dates are never comparing correctly because they're coming out like this:

 

Run If  9/25/2018 1:01:45 PM = 9/25/2018 12:00:00 AM

 

I would like an email to send if  9/25/2018 = 9/25/2018     

 

How can I trim the string so only the date shows? I would like the string after 2018 ignored and extracted into a variable because if I count from the beginning or end to trim it, when the month is a 2-digit month the results will be different. I need to change 9/25/2018 1:01:45 PM  to be only 9/25/2018 and extract to a variable. Any ideas? 

 

Outcomes