Forum Discussion

Copper Contributor

Oct 24, 2019

Solved

Not all date fields are showing up in Timeline slicer option

I have two fields (reqd date and promisedshipdate in table. Both are formatted as date. When a do a Pivot table of this table and try to create a timeline slicer the promisedship date does not show �...

excel

SergeiBaklan
Oct 24, 2019
IWT_GG

You may format cells as dates but actually have texts within it. You may check by ISTEXT() if so or not.

IWT_GG

Copper Contributor

Oct 26, 2019

Yes problem solved. I used date(0,1,1) to ensure all default values are in Date format

Thank you for your help

AAbdou

Copper Contributor

Oct 27, 2019

HiIWT_GG ,

I'm glad that your problem has been solved.

Abdelrahman Abdou,

Certified Microsoft Excel Expert, Consultant.

Founder, Owner @ ExcelBonanza.com

http://www.excelbonanza.com/ |

https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/