Add text to Date Time field

M

Mary

Trying again -- don't see my post after several minutes.

How can I add CT immediately after my Date/Time field.

I've tried:
=[PLANNED_START_DATE] & "CT"

I get #Error on the report. I've combined fields using this method, but
don't know how to add text following a field.
Thanks,
Mary
 
F

fredg

Trying again -- don't see my post after several minutes.

How can I add CT immediately after my Date/Time field.

I've tried:
=[PLANNED_START_DATE] & "CT"

I get #Error on the report. I've combined fields using this method, but
don't know how to add text following a field.
Thanks,
Mary
Click to expand...

1) If the name of this control is "PLANNED_START_DATE" you will get an
#error. Change the name.

2) You may want to format the date at the same time you add the "CT"
=Format([PLANNED_START_DATE] ,"mmmm d, yyyy") & " CT"

April 8, 2005 CT
 
M

Mary

Thanks - I know better, can't even believe I did that!!

Thanks for helping me out.
Mary

fredg said:
Trying again -- don't see my post after several minutes.

How can I add CT immediately after my Date/Time field.

I've tried:
=[PLANNED_START_DATE] & "CT"

I get #Error on the report. I've combined fields using this method, but
don't know how to add text following a field.
Thanks,
Mary
Click to expand...

1) If the name of this control is "PLANNED_START_DATE" you will get an
#error. Change the name.

2) You may want to format the date at the same time you add the "CT"
=Format([PLANNED_START_DATE] ,"mmmm d, yyyy") & " CT"

April 8, 2005 CT
Click to expand...
 
Top