Filter Data based of dates

[swapsingh2712]

Hello All,

I've created a alteryx workflow which is generating rows (Month column) based on the activation and decommission dates mentioned in the datasets.

Also I've added the functionality where it is filtering the data on the "Evaluation Frequency" Column and the rows are getting calculated based on the "recent_testing_month" column

So if the evaluation frequency is quarterly, it's 3 months previous and 3 months forward rows based on the recent testing month column (here the filter should only based on the month).

for example - if recent testing month is in  December 2021 then it should show sept 2021 and march 2022

For semi-annual, it's 6 months and for annual it's  12 months.

but for some reason, the month calculation is showing incorrect (so far I checked for semi-annual and annual)

Could you please help.

Please find the alteryx workflow and dataset in the attachment 

Regards,

swapsingh

[atcodedog05]

Hi @swapsingh2712 

Can you provide me the expected output.

Happy to help : )

[atcodedog05]

Hi @swapsingh2712 

Try this formula out its doing what you are asking. Check it on a smaller data to get to know.

Hope this helps : )

[swapsingh2712]

Hello @atcodedog05 

Thank you so much for your response. The formula worked for the entire dataset. For some reason, the dates showing incorrect for two tests TI712 and TI1555 (annual)

The recent-testing_month date is 2021-03-31 19:00:00 and 2021-05-31 19:00:00 and after running the workflow, it should show dates 2021-03-31 and 2022-03-31 for TI712 

 dates 2021-05-31 and 2022-05-31 for TI1555 in months column

like how the other tests are getting calculated. I've attached the workflow.

Could you please advise

BR

Swapsingh2712

[atcodedog05]

Hi @swapsingh2712 

Sorry, it's not clear what the issue is can you highlight it in the data and show me.

Happy to help : )

[swapsingh2712]

Hello @atcodedog05 

I've attached the excel which contains two sheets

In sheet - "Data after running the alteryx" shows the data after running the workflow

In sheet - "Error Tests" contains the test where the data on month column is giving incorrect date.

The recent-testing_month date is 2021-03-31 19:00:00 for TI712  and  after running the workflow, it should show dates 2021-03-31 and 2022-03-31 for TI712 (as per the recent_testing_month)

The recent-testing_month date is 2021-05-31 19:00:00 for TI1555  and after running the workflow, it should show dates 2021-05-31 and 2022-05-31 for TI712 (as per the recent_testing_month) as per the logic as other entries are working fine

but it's giving the incorrect date which is 2021-08-16

Please advise and let me know if you've any questions