Date conditional logic in workflow? | Community
Skip to main content
Robb_Barrett
Robb_Barrett
Level 10
March 28, 2016
Solved

Date conditional logic in workflow?

  • March 28, 2016
  • 2 replies
  • 3555 views

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"

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

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

2 replies

A
Anonymous
March 28, 2016

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

Robb_Barrett
Robb_BarrettAuthor
Level 10
March 28, 2016

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.

Robb Barrett
Grégoire_Miche2
Grégoire_Miche2
Level 10
March 28, 2016

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

Robb_Barrett
Robb_BarrettAuthor
Level 10
March 28, 2016

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

Robb Barrett
Grégoire_Miche2
Grégoire_Miche2Accepted solution
Level 10
March 28, 2016

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

Terms & ConditionsAccessibility statement

Loading footer...