Forum Discussion
Filter on Date but not Time
My objective: I have a column which contains a DateTime. I want to use it in a Visualisation, and be able to filter on the Date part only. E.g. I want to filter all the records with a Date of 2nd F...
Try this:
Request Date = DATE(YEAR(Requests[Request Submitted Date]),MONTH(Requests[Request Submitted Date]),DAY(Requests[Request Submitted Date]))
Greg_Deckler
Community Champion
Community ChampionTry this:
Request Date = DATE(YEAR(Requests[Request Submitted Date]),MONTH(Requests[Request Submitted Date]),DAY(Requests[Request Submitted Date]))
Smashing, that worked a treat. Thanks for your time & help -- much appreciated.
- Greg_Deckler
Awesome! :)