Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi,
I was able to do what the code seemed to interest someone
Code:
expression >= AddMonths(Today(),-3)
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)
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));
Hi,
I was able to do what the code seemed to interest someone
Code:
expression >= AddMonths(Today(),-3)