Hi All, Can somebody help me with my scenario? I have one input as a database, with an example below. Example: Input sample IDCompany_namecontract_agreementDateQuantityPriceT1McDonalds678292022-03-31453.25T2Burger King125492022-11-252665.51T3Wendys365482022-12-20226.54T4Chick-fil-a456242023-01-0442.36T5In-N-Out458722024-06-068936.48 I will be running this workflow on January 1st 2023, 2024, 2025,... so ideally what this filter would do is filter out rows T4 and T5 because they come after December 31st 2022 and when I run it next time on January 1st 2024 it would only filter out T5 because it comes after December 31st 2023.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter for dates after December 31 of the previous year

Travis_Ratliff

Hi All,

Can somebody help me with my scenario?

I have one input as a database, with an example below.

Example:

Input sample

ID	Company_name	contract_agreement	Date	Quantity	Price
T1	McDonalds	67829	2022-03-31	45	3.25
T2	Burger King	12549	2022-11-25	26	65.51
T3	Wendys	36548	2022-12-20	2	26.54
T4	Chick-fil-a	45624	2023-01-04	4	2.36
T5	In-N-Out	45872	2024-06-06	89	36.48

I will be running this workflow on January 1st 2023, 2024, 2025,... so ideally what this filter would do is filter out rows T4 and T5 because they come after December 31st 2022 and when I run it next time on January 1st 2024 it would only filter out T5 because it comes after December 31st 2023.

Workflow

Datasets

Custom Tools

Date Time

Accepted answers

IraWatt

ahhh okay that straight forward enough. I added a datetimeadd function which minuses 1 year off the current date then sets it to December 31st of that year:

Workflow.yxmd

All comments

IraWatt

Hey @Travis_Ratliff,

Here is one way to do this using the datetime functions in a filter tool:

Essentially I use the datetimenow function to get the current date and from that I get the current year. Then I just create a date from that set at the end of December this year and filter from that.

If your interested in learning more about the datetime functions there is a great cheat sheet Blog here: https://community.alteryx.com/t5/Engine-Works/DateTime-Functions-Cheat-Sheet/ba-p/844353

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

Travis_Ratliff

So, if I ran this on January 1st 2023 it would filter for the dates after "2023-12-31" because that is the current year. But I would want it to filter for dates after "2022-12-31". So that is what I am trying to do is figure out how to filter it for the previous year. I hope that makes sense.

IraWatt

ahhh okay that straight forward enough. I added a datetimeadd function which minuses 1 year off the current date then sets it to December 31st of that year:

Workflow.yxmd

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15906

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703