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

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

        Hi kintela，

        I download your file and extract it, but I don't fine .pbix file. Do you mind download again?

         

        >>I don't understand what are you saying "check it returns null when the filter is "no" for the value level in your report"

        I mean if you add other filter, which laed to the report don't return any value when you click No.

        Best Regards,
        Angelia