FORMAT DATE IN CONCATENATED CONTROL

Sammie · Jul 22, 2005

How can I format a date field in a concatenated control? I want
mmmm d yyyy format.
=[Field1] & " " & [DateDue]
Thanks
Sammie

Allen Browne · Jul 22, 2005

Try the Format() function:
=[Field1] & " " & Format([DateDue], "mmmm d yyyy")

Sammie · Jul 22, 2005

Allen said:
Try the Format() function:
=[Field1] & " " & Format([DateDue], "mmmm d yyyy")

works!
Thanks,
Sammie