Date to word document


#1

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


#2

You need to handle the formatting.

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


#3

Thanks, it is working!