Remove hours and minutes from a date field
Mohamed
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur 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.
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 réponses
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
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