Forum Discussion

kintela's avatar
kintela
Helper II
9 years ago

using NOW() in filters

Hi   I need to filter by records with date > NOW() but in the filters in the Report if I put NOW() in the calendar does not work   I have created a calculated column      So all th...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Seems like you did it correctly...

  • kintela's avatar
    kintela
    Helper II
    9 years ago

    I have this records not out of time

     

     

    that is, FECHAPRES>NOW() but in the report when I apply this filter dissapear

     

    And this is the only one filter

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi kintela,

      Please check it returns null when the filter is "no" for the value level in your report? Based on your screenshot, it works fine, and I am unable to reproduce your scenario according your given information. Would you mind share your .pbix file for further analysis?

      Best Regards,
      Angelia