Date to word document

Hi,

I have a record which I use in a word document. I use office templates form Softmasters. When I want to add a date field (D17) to the document I get the 5 digits instead of the real long date. Is there a way to use the long date (D17)

Thanks

You need to handle the formatting.

CLIP(LEFT(FORMAT(MyDate,@d17)))

1 Like

Thanks, it is working!