View original (French)

Remove hours and minutes from a date field

Mohamed -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

I am a beginner and I want to remove the hours and minutes from my date.
This makes it impossible for me to group my data by reception date in a PivotTable.
Thank you.

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    In a Pivot Table, you can 'Group...' by day (and/or month and/or year) by right-clicking on the field without having to adjust the dates.
    https://www.cjoint.com/c/EGin6w82OYh
    eric

    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it will work. (the Shadoks)
    In addition to saying thank you (yes, it is done!!!), remember to mark as resolved. Thank you
    2