Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Remove Time Stamp from Date

I have a "Start Time" field which has a standard date with a time stamp - hours, minutes seconds.  When I create a date slicer, all the various time stamps show up in the list (see image).  What I wa...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi ConnieMaldonado 

    you can create a column like

    Column = FORMAT([Datetime];"DD.MM.YYYY")

    and use it as slicer

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

ConnieMaldonado change the data type to date, you can do it two ways, go to query editor and change type by clicking the icon on the column header (prefered way) or changing data type column tool tab by selecting the date column