Forum Discussion
How to filter data for rolling 24 months using SAP BW BEx Query
Hello Everyone, I have to pass two required parameters StartDate and EndDate at the BEx query level. If I pass Start Date as "20220101" and EndDate as "20220131", these values are fixed in the p...
praveenk , Use these two dates
Let
StartDate =Date.AddMonths(DateTime.Date( DateTime.FixedLocalNow()),-24),
EndDate= DateTime.Date( DateTime.FixedLocalNow()) ,
<Use these two in you code now>
I don't see the data beyond the parameter's value after adding those two lines to the code. Do I have to remove the date values and substitute them with the StartDate and EndDate?