Date with leading zero... Excel is being a smart-***

[Glory]

"01/01/2011" consistently appears as "1/01/2011", no matter what I do.

I can format the display format of a date in a pivot field as mm/dd/yyyy. But I can't format the date as it appears in the pivot field's drop-down list.

This is causing problems with code I'm using to select certain dates from the page field.

Any ideas why nothing I do to format the date will make it appear correctly?

 

[Norie]

So have you got a solution?

I managed to get something working, but it wasn't with a page field.

PS I don't recall mentioning an advanced filter in this thread.

 

[Glory]

This thread. And thanks, it's way way faster now I've got that up and running.

Well CDate stops the code from being unable to match dates in "mm/dd/yyyy" format. But no, I don't have an answer to the original question, which is how to edit the format of page-level pivot items in a pivotfield's dropdown.