Date

Question

Hi,

I’m trying to create exception reporting where if a file was released on 1/2/2022 from Event tracking Report and it’s not reflected on Disposition Report on the day it was released or after 3 days it was released, then it will be an exception.

I just need assistance what formula or expression should I use in order for me to get that.

MarqueeCrew · Accepted Answer

@Alwin21

ISO date format is YYYY-MM-DD

You need to convert "1/2/2022" to 2022-01-02 with:

DateTimeParse([Release Date],"%m/%d/%Y")

if the date is February 1st then:

DateTimeParse([Release Date],"%d/%m/%Y")

Then you can add 3 days with:

DateTimeAdd(DateTimeParse([Release Date],"%m/%d/%Y"),3,"days")

Cheers,

Mark

Luke_C · Accepted Answer

Hi @Alwin21

Do you have some sample data? If you're using a directory tool, you could place a filter after and use a condition like the below to get all files from the last 3 days. I'd urge you to check out this page on datetime functions and give it a go yourself. If you can share sample data/what you've tried in alteryx we can help you further. https://help.alteryx.com/current/designer/datetime-functions

[CreationTime]>=Datetimeadd(datetimetoday(),-3,'days')