Forum Discussion

CarlBlunck's avatar
CarlBlunck
Icon for Resolver I rankResolver I
3 years ago
Solved

Filter greater than today

Hello,   I have a datetime column that I need to filter so it only shows the values that are greater than today.  My understanding is that if use  DateTime.LocalNow() It will give the today's dat...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , CarlBlunck 

    You can use this M language to get " today's date with 00:00:00 ":

    DateTime.From(Date.From(DateTime.LocalNow()))

    The result is as follows:

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , CarlBlunck 

You can use this M language to get " today's date with 00:00:00 ":

DateTime.From(Date.From(DateTime.LocalNow()))

The result is as follows:

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly