Date filter on year

[Luke_Killer_IT]

Hello,

Can you help me filter the date in the script? I want the filters to give me only the numbers of the week until 2021 and 2020 is to be listed

Script:

Where (Year(MMT_MRPAccount.MRPDate) <= Year(Today())) and ( Week(MMT_MRPAccount.MRPDate) and (year(MMT_MRPAccount.MRPDate)=2021)) <= (Week(Today()) + WeekName(3));

It is scheduled to end on week 28

[MayilVahanan · Accepted solution]

Hi 
Try like below

Where MMT_MRPAccount.MRPDate <=MakeWeekDate(Year(Today()),Week(Weekend(Today()+21)));

-- you can change based on ur requirement instead of this (Weekend(Today()+21)

[ElsieSmith]

1. Select the Data tab, then click the Filter command. A drop-down arrow will appear in the header cell for each column.  official site
2. Click the drop-down arrow for the column you want to filter. 
3. The Filter menu will appear. 
4. The worksheet will be filtered by the selected date filter.

[Luke_Killer_IT]

Hi @MayilVahanan ,
I have a similar problem, but now the other way around I have to narrow my search down to 3 months back from the current month.

 my code:

MLL_Movements.Postingdate >= MakeWeekDate(Year(Today()),Month(Today()-105));

[Luke_Killer_IT · Accepted solution]

Hi, 

I was able to do what the code seemed to interest someone

Code:

expression >= AddMonths(Today(),-3)