Filter query table based on dates

**Undo** · 09-17-2021, 07:46 AM

Hey

How can I filter the query table within "From" "To" dates, to show only running and next 3 weeks records?

**AliGW** · 09-17-2021, 07:53 AM

You have given us two identical tables. Where have you manually mocked up what you want?

**Undo** · 09-17-2021, 07:57 AM

The query table ( right one ), not the normal table
its ready just need to filter

**alansidman** · 09-17-2021, 08:03 AM

Your next line of Mcode is:

= Table.SelectRows(#"Changed Type", each Date.IsInNextNWeeks([to], 3))

Clcik on the drop down arrow in the To column and select "Is In Next"

**Undo** · 09-17-2021, 08:15 AM

@alansidman This will only show the records will end in next 3 weeks, but it will not show all running records
example, from 25/9/2021 to 30/10/2021, this will run in next 3 week but it will not show, because it will not end in next 3 weeks

explain again I need to show running records+ the records will start in next 3 weeks

**alansidman** · 09-17-2021, 08:53 AM

Sorry, cannot figure out syntax for your needs. If you can provide the excel syntax if you were doing an if then statement, I might be able to get it. But right now, I don't see the syntax for your needs. Good Luck.

**Undo** · 09-17-2021, 09:34 AM

I think this will work but how to go with it?
FILTER : IF "FROM" in the next 3 weeks OR "FROM" >= TODAY AND "TO" <= TODAY

**alansidman** · 09-17-2021, 11:34 AM

Will work on this later today. Got errands, etc to do.

Alan

Edit: Back and worked on this for an hour with no success. Will ask other for help.

Filter query table based on dates

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Re: Filter query table based on dates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to filter pivot table by rows containing dates for dates < 60 months old

Will pivot table update with new dates without needing to select the dates in the filter?

Filter recognizes dates, but Pivot Table filter does not

Filter Pivot Table Based on Current Dates

MS QUERY - Filter To Show Only Dates Within This Month

Pivot Table: Filter dates based on a date in another cell

Select Multiple Dates In Report Filter Pivot Table But Dates Are Not Static

Bookmarks

Bookmarks

Posting Permissions