This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.
You can use a filter tool with the following expression
// check if day workflow runs is Monday
//keep previous 1 to 3 days
//keep previous day
Dateteimdiff functions find the days between todays date and previous days and the Datetimetrim function trims all days to midnight. So today is the 1st of June, but if you had a record for the 31 of May 23:59:50 you would like to show that record because it is in the previous day, although technically 24 hours have not gone by
I made some slight change to accommodate your existing fields and show you the variation. Just remove the // in front of datetimetoday() in today formula and remove the manually set date for running in the actual scenario.
Can you elaborate more when you say it's not working? Today is Tuesday, so we should keep only records for the previous day. Yesterday was Monday the 31st of May, and this falls out of the T output anchor