Hi All, I'm new to this, I'm trying to create Pivot table but the date is showing both the date and time value. Any ideas on how to convert this to date only. I've changed the date format already in both data and Pivot but it doesn't work. Please see below Pivot sample. Thank you in advance.