Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Disable Container Based on Date

Adrian01
6 - Meteoroid

I'm basically wanting to disable a container based on Today's day. I've tried multiple setups but I can't seem to get the container to disable. If it is not Saturday then remain enabled, vice-versa. 

fmvizcaino
16 - Nebula
16 - Nebula

Hi @Adrian01 ,

 

You were almost right. The only thing you need to update is your condition formula to:

DateTimeFormat(datetimetoday(),"%A")='Saturday'

 

Let me know if that works for you.

Best,

Fernando Vizcaino

Adrian01
6 - Meteoroid

I changed the condition to test for the day being "Tuesday" but the container still has a text output. I have tested the IFF condition in a formula tool on another workflow and it outputs as "True" when I change it to "Tuesday".

 

What am I doing wrong? Or is there a better way to basically shut off this input from processing?

 

DavidP
16 - Nebula
16 - Nebula

Here's how I did it.

 

disable container 1.pngdisable container 2.png

fmvizcaino
16 - Nebula
16 - Nebula

Hi @Adrian01 ,

 

Remove the iif clause from the condition and leave the formula as:

DateTimeFormat(datetimetoday(),"%A")='Tuesday'

It will work this way.

Adrian01
6 - Meteoroid

This doesn't work as it still has a text input. Am I missing something?

Labels