Dynamically filtering for a date range that includes hours, minutes and seconds

[schuprov]

Hi all,

I am struggling to write a filter formula for one of my workflows as I am not that good with datetime formulas.

Can you please help me write a filter formula where I want to filter out all transactions that are between two days ago from 3am till one day ago at 2:59:59 am.

My Column is called TransactionDate and it comes in the following format "yyyy-MM-dd hh:mm:ss"

Thank you so much for your help.

[binu_acs]

@schuprov Can you upload some sample data and expected output

[schuprov]

@binu_acs for example if i have four transactions:
1. 2023-12-17 01:00:00

2. 2023-12-17 03:01:00

3. 2023-12-18 02:30:00

4. 2023-12-18 03:05:00

i want alteryx to dynamically everyday to only pick up the transactions that are within my time range which is from two days ago at 3am and one day ago 2;59;59.

So under the example above the true anchor of the filter will only output transactions 2 and 3, since 1 and 4 are outside those dates

[binu_acs · Accepted solution]

@schuprov one way of doing this

[schuprov]

@binu_acs that worked perfectly, thank you so much. I was just missing the todate function before my formula.

appreciate your quick response! accepting your answer as a solution!