Hi Foxfire,

I am unable to replicate that behaviour. Are you sure your SQL DB outputs the dates in the correct (ie dd/mm/yy) format?

What happens if you make a copy of the field and change:
{SET StartDate {MERGEFIELD "Tenant_Paid_To"}}
to:
{ASK StartDate "Tenant_Paid_To?"}
and update the field manually (via F9) and inputting various dates?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]