Forum Discussion

CarlBlunck's avatar
CarlBlunck
Resolver 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 date and the current time.  But I need it to be today's date with 00:00:00  as the time portion.

 

How do I achieve this?

 

Thanks

Carl

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

     

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community 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