In the last blog I mentioned the joys of Y2K, it seems Visio has a Y2K problem, but there is no rush to tell them, it will not reoccur until Jan 1, 3000.
I have updated the sample table to include these examples.
The Y2K bug? if you look at Times_Minutes, m supresses leading zeroes but mm does not. Compare that to Date_Year_2000, y does NOT suppress leading zeroes.
and the downloads reflect the change. I have included a Word document that lists the examples, the formats and the results. Creating the list was trivial, Visio has a Print Shapesheet and I just selected the User section to print to the clipboard. Paste into Word and run a VBA macro and everything is pretty. (I love VBA, even if it is in Word. 😉 ).
My documentation still needs updating.
I hope you find this useful.
John… Visio MVP in x-aisle