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 ChampionWell, one way would be to create a new column that is only a Date colum and not a DateTime column (as in the data type). You would just set it equal to your current date/time column.
Thanks smoupre. I actually tried exactly that.
My new column definition reads:
Request Date = Requests[Request Submitted Date]
And the data type for this column is Date (not DateTime).
But the behaviour of both columns is the same, in the Filter pane. Is there another step I need to take? Thanks.
- Greg_Deckler
Try 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.