Skip to main content
3 个回答
  1. 2025年5月27日 09:50

    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 ]

     

    Hi @Chris Geatch​ I need backdate data and another issue i seemanagment cut off day selected as 0 then need to show only 05/11/2025 data it is not showing with this formula.I tried with below formula will this work with my requirement ?

     

    Date(Rundate) = Date(Dateadd('day',-[management cutoff day], [Rundate parameter]

    image 

     

    Result Expected back date data: 05/02/2025 to 05/11/2025

0/9000