FORMAT DATE IN CONCATENATED CONTROL

  • Thread starter Thread starter Sammie
  • Start date Start date
S

Sammie

How can I format a date field in a concatenated control? I want
mmmm d yyyy format.
=[Field1] & " " & [DateDue]
Thanks
Sammie
 
Try the Format() function:
=[Field1] & " " & Format([DateDue], "mmmm d yyyy")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date (multiple) format in textbox 1
Hard-coding a date 1
Date Concatenation 3
Rich Text Format 0
Format part of a concatenated control 1
Date Heading 6
concatenated field in a report is not sorted 1
Strange unbound control problem 6

Back
Top