Get Current Month and last month

[nd1992]

Hi
I have a string column in the form of yyyyMMdd
I want rows to filter by current month and last month.
For eg- Current month is September, then I want entries of only of September and August even if the date is 1st September.
I tried P2M in date row filter but it will also include July data if date is 1st September.
Also tried Time Difference node combined with row filter on attribute value. Same Issue.

Any ideas on how to do this?
Thanks

[armingrudd]

Hi @nd1992,

Here is an example to check:

date_filter.knwf (29.3 KB)

I have created a date range using the Create Date&Time Range node and have filtered the main table based on the current month and the last month.

Edited: Now filters the current and the last month. The previous workflow was filtering the current and the next month.

[nd1992]

Thanks. Works !!

[armingrudd]

Dear @nd1992,

Please check the edited version. The last workflow was filtering the next month instead of the last month.

The change is in the configurations of the Create Date&Time Range node where the “Interval” value is now “-1M” instead of “1M”.

Sorry for the mistake.

[umutcankurt]

[nd1992]

Yes,no worries. I made the changes accordingly. Thanks for the swift response. It helped a lot!!