Forum

Notifications
Clear all

Date question

4 Posts
2 Users
0 Reactions
190 Views
(@louise)
Posts: 3
Active Member
Topic starter
 

Hi Phil / Mynda

At 4min 50sec on 5.02 class, my dates don't get grouped into years/ quarters / months on the pivot table. Only month and only shows one date, the first date (1/1/2019).

What should I do to fix this? Is it a problem with the date data?

Thanks

Louise Dever

 
Posted : 04/04/2021 9:55 pm
(@louise)
Posts: 3
Active Member
Topic starter
 

It's ok - i right clicked and grouped / ungrouped

 
Posted : 04/04/2021 9:59 pm
(@louise)
Posts: 3
Active Member
Topic starter
 

Actually nope - now I am on to 5.04 and my dates and years are not coming up. I only have January 2019. 

 
Posted : 04/04/2021 11:55 pm
(@mynda)
Posts: 4761
Member Admin
 

Please share your file, Louise. I suspect you have a locale issue.

 
Posted : 06/04/2021 8:03 pm
Share: