How to change Date Picker content control format based on date comparison

[macropod]

Try making the Call the first line, or thereabouts, in your Sub.