Example: Rundate parameter 05/11/2025 selected and Management cutoff days selected 10.
Attached workbook
3 risposte
Hi @Chris Geatch
I need backdate data and another issue i see
managment cut off day selected as 0 then need to show only 05/11/2025 data it is not showing with this formula.
DATEDIFF('day',[RunDate Parameter],[RunDate]) >= 0
AND
DATEDIFF('day',[RunDate Parameter],[RunDate]) < [Management Cutoff day ]
I tried with below formula will this work with my requirement ?
Date(Rundate) = Date(Dateadd('day',-[management cutoff day], [Rundate parameter]
Result Expected back date data: 05/02/2025 to 05/11/2025