How do I get just the local date and not the time with it ?

[EaglesTony]

I have an M query as follows:

each if([SprintStartDate] <= Date.From(DateTime.LocalNow()) then <some logic>

this logic is not working, as it does not consider DateTime.LocalNow() as just a date.

I just need to get the date as my SprintStartDate is 1/17/2024 format.

Thanks,

[EaglesTony · Accepted solution]

I figured it out, for those that need it :

each if([SprintStartDate] <= Date.From(DateTime.Date(DateTime.LocalNow())) then <some logic>