Date Field in a text string

  • Thread starter Thread starter gearykl
  • Start date Start date
G

gearykl

How do I use a date field in a text string? This one is not working?
=" MOPS Change Control Summary - Effective Date: " & " Requested
Completion Date"
Requested Completion Date is my text field.

Thnx
 
How do I use a date field in a text string? This one is not working?
=" MOPS Change Control Summary - Effective Date: " & " Requested
Completion Date"
Requested Completion Date is my text field.

Thnx
Click to expand...

No Quotes and you need brackets because the field name has spaces in it.

="MOPS Change Control Summary - Effective Date: " & [Requested Completion
Date]
 
[email protected] said:
How do I use adatefieldin a text string?  This one is not working?
=" MOPS Change Control Summary - EffectiveDate: " & " Requested
CompletionDate"
Requested CompletionDateis my textfield.
Click to expand...
Thnx
Click to expand...

No Quotes and you need brackets because thefieldname has spaces in it.

="MOPS Change Control Summary - EffectiveDate: " & [Requested CompletionDate]
Click to expand...

Thanks so much!! It worked!!

KGeary
 
Back
Top