@HTSCF Fareha I don't see the date flipping issue here, but I have modified the code to give a belt and braces setting of the format.
@Bob Phillips Of course you are right about the 64 bit issue. Unfortunately I copied an older version which included the title bar code, rather than the version I normally use, which has the title bar code in a separate module and is 64 bit compatible. I have swapped it out in the example. I will also update my old copy of the date picker code. Thanks for bringing it to my attention.
The date picker was created originally for Excel by Trevor Eyre and my friend and occasional forum contributor Greg Maxey and I adapted it, with Trevor's approval, to work with Word. I particularly like this date picker because it is highly configurable to user requirements and have used it in several of my own projects.