Pivot Table Date Filters

%3CLINGO-SUB%20id%3D%22lingo-sub-1604619%22%20slang%3D%22en-US%22%3EPivot%20Table%20Date%20Filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604619%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20date%20filter%20that%20contains%20multiple%20dates%20(multiple%20months%2C%20days%20and%20years).%20I%20forget%20how%20to%20change%20the%20formatting%20so%20that%20when%20searching%20I%20can%20type%20%222020-07%22%20instead%20of%20selecting%20every%20day%20in%20July%20to%20be%20displayed.%20I%20have%20other%20pivots%20in%20this%20template%20that%20do%20this%2C%20but%20I%20cannot%20remember%20how%20to%20apply%20it%20the%20new%20pivot%20table%20I'm%20creating.%20Please%20help!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605843%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Date%20Filters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767357%22%20target%3D%22_blank%22%3E%40VeronicaL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20right%20on%20any%20date%20within%2C%20Field%20Settings-%26gt%3BNumber%20format%20and%20apply%20custom%20format%20as%20yyyy-mm-dd.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlternatively%20you%20may%20use%20wildcards%20in%20the%20filter%20search%2C%20like%20*%2F07%2F2020%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a date filter that contains multiple dates (multiple months, days and years). I forget how to change the formatting so that when searching I can type "2020-07" instead of selecting every day in July to be displayed. I have other pivots in this template that do this, but I cannot remember how to apply it the new pivot table I'm creating. Please help!  

1 Reply
Highlighted

@VeronicaL 

You may right on any date within, Field Settings->Number format and apply custom format as yyyy-mm-dd.

 

Alternatively you may use wildcards in the filter search, like */07/2020