I have a date stored in CRM for a vendor, which I need to break into separate fields in the contract. The field is called «Contacts.Contract Date» which appears as MM/DD/YYYY

I need it to appear on a line of the contract as: 

Effective this     <<DD>>    day of        <<MMMM>>       , 20     <<YY>>      (and retroactive to the first day of...

I tried creating a new date field with the formatting changed to DD, which seems to appear alright on the setup, but when merged it always shows the whole date. 

Is there a formula I should use instead? If I was writing this in excel, I would just use =text(«Contacts.Contract Date»,"DD") and be done, but I'm not sure how to do that here. 

Any advice or maybe direction to a resource that would help?