condition evaluating a date field

[Anonymous]

I have a string type field that saves a date with the following format

January 5, 2020 9:21 PM

I want to evaluate the following

If the field date is equal to the field date minus 30 minutes

I know it is done in an expression, but I have no idea how to do it.

all this with the aim of sending a notification 30 minutes before that date

[Jay-Encodian · Accepted solution]

Hi @Anonymous 

This is the expression to parse the string to ISO 8601 format (yyyy-MM-ddThh:mm:ssZ): formatDateTime('January 22, 2020 9:21 PM','yyyy-MM-ddTHH:mm:ssZ')

You can then add required minutes to the datetime value: addMinutes(formatDateTime('January 22, 2020 9:21 PM','yyyy-MM-ddTHH:mm:ssZ'),-30)

Example using the above expressions with the Compose action:

Ref date comparison... it's a little hard to advise as I don't follow your logic, it's impossible for a value to be equal to itself minus a value?!? 🙂

I'm guessing you would compare against another datetime value or the current time (utcNow())...

HTH

Jay

-------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up