SOLVED

Date conditional logic in workflow?

Go to solution
Highlighted
Level 8

Date conditional logic in workflow?

Question for the experts on how you'd accomplish this:

I have Webinar programs and I want to set status based on conditional dates.

Apparently this is not allowed:

IF {{system.datetime}} IS AFTER {{my.Webinar Date}} then CHANGE PROGRAM STATUS TO "Attended On Demand"

Else if

{{system.datetime}} IS EARLIER THAN {{my.Webinar Date}} then CHANGE PROGRAM STATUS TO "Registered for Event"

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Date conditional logic in workflow?

Well,

BECAUSE , AFAIK, this simply not possible to use a token in a choice. Hence the Idea to vote for. But this is something I have not been testing for a while, so may be it would be worth giving it a try and I would be pleased to be wrong on this

-Greg

View solution in original post

6 REPLIES 6
Highlighted
Anonymous
Not applicable

Re: Date conditional logic in workflow?

Hi Robb,

Did you try,

IF {{my.Webinar Date}}  is BEFORE {{system.datetime}} then CHANGE PROGRAM STATUS TO "Attended On Demand"

Else if

{{my.Webinar Date}}  is LATER THAN {{system.datetime}} then CHANGE PROGRAM STATUS TO "Registered for Event"

instead?

That might work. I did not execute the smart campaign I created to test it. But Marketo did not give an error (red underline) on anything on the flow step.

Other option,

Use a 'webhook' to compare 2 dates. At BrightHooks.com, I have a webhook that accepts 2 dates, compares them and returns 'true' or 'false' if date1 is earlier than date2. You can save it in a field and use it for conditional processing in the nest flow step.

Hope this helps

Rajesh Talele

Highlighted
Level 8

Re: Date conditional logic in workflow?

Doesn't work.  I tried Fills Out Form After Date and I tried a conditional on the Change Program Status flow date.  Dynamic values not allowed.

Highlighted

Re: Date conditional logic in workflow?

HI Robb,

Start with a vote here:

You could create a formula lead field which value would be {{system.datetime}}, but you will still not be able to compare it to {{my.webinar date}}.

-Greg

Highlighted
Level 8

Re: Date conditional logic in workflow?

GM - you need to finish that sentence with a BECAUSE....

Highlighted

Re: Date conditional logic in workflow?

Well,

BECAUSE , AFAIK, this simply not possible to use a token in a choice. Hence the Idea to vote for. But this is something I have not been testing for a while, so may be it would be worth giving it a try and I would be pleased to be wrong on this

-Greg

View solution in original post

Highlighted
Level 8

Re: Date conditional logic in workflow?

You're correct. There's no way to compare dates.