Formula to assign value if workflow is run at a certain time??

[Deano478]

Hi Alteryx Crew,

I'm currently having what could possibly be a simple problem to solve I just cant see a solution to it. Basically What I'm trying to do create a formula that when my workflow runs between the hours of 14:00 and 15:00 it will assign the value 'Deadline 1' to my data.

However if the Workflow is run before 14:00 or after 15:00 then I just want the workflow to stop.

I hope I was able to explain myself well enough if not i'll do my best to provide any additional info. A huge thanks to you all in advance.

Kind regards,

Dean 

[DavidSkaife · Accepted solution]

Hi @Deano478 

This should work for you, if you add it to the start of your workflow:

Using the Message tool to stop downstream proccessing if the date condition isn't met:

[Deano478 · Accepted solution]

Hey @DavidSkaife,

I attached a screenshot I don't think I added it to my WF properly should I have implemented this in a different way? 

[DavidSkaife · Accepted solution]

Hi @Deano478 

Instead of Union try Appending it. That will add the result "Deadline 1", if applicable, to all rows. 

Personally i'd append it before the first Select tool, that way nothing else processes.

Is it working correctly?

[Deano478]

@DavidSkaife you my friend are a genius ahaha i appended it now and boom its working thank you so much 

[DavidSkaife]

@Deano478 you're very welcome!

Credit to @JosephSerpis as well for telling me about using the Message Tool in this way a while ago :)