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

Question

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 Answer

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 Answer

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 Answer

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?