Convert a Date field into Day of Week in a report header 1

[molly]

I have a date field named CallDate. I have this field in a report header. I would like it to show the day of week. EG Monday or whatever the date converts to.

I tried in the field on the Format row:

=Format([CallDate],"dddd")

but i received an error. It came back as:
"=For"m"at(["c"all"d"ate],dddd)"

Any ideas?
Regards, Molly

 

[dhookom]

Enter your expression in the Control Source, not the format property. Make sure the name of the control is not a field name.

Duane
Hook'D on Access
MS Access MVP

 

[molly]

Thanks Duane. It worked. I should have known to use the control line.

=Format([CallDate],"dddd")

Molly