Skip to main content

Example: Rundate parameter 05/11/2025 selected and Management cutoff days selected 10.  

 

Hi   I am new to parameter can you please help on below query.  How to restrict dates when user select rundate and management cutoff days. 

image 

Attached workbook

3 risposte
  1. 27 mag 2025, 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