DatePicker Formatting Issue

Question

Hello,

I am trying to set a custom format in DT Picker Object Properties by:

1. Selecting 3-dtpCustom
2. In the custom format bar typing mm/dd/yy

It applies the format but for say 05/07/12, the date shows as 00/07/12. It actually puts the correct date into the linked cell but because the control doesn't disappear (as it did with calendar controls in earlier versions), it has to be right.  I'm dragging the datepicker overtop of the cells from which calculations are performed.

Any help - much appreciated!

thanks

Answer 1

You need to use upper case M for month - m is for minutes.

So use MM/dd/yy

Answer 2

So simple...I can't believe how much time I wasted on this.  THANKS!!!