How to make the Day pull from a Date?

[BurtonBach]

I have attempted to search this, because I'm sure someone else has asked the question, but I must not be using the correct search terms.

I have a report in which one column is a standard date (mm/dd/yyyy). From this field I would like to have the name of the day show in the next column, i.e., Monday. Is this possible without major programming?

Thanks in advance!

[pks00]

Is your report based on a query?
simplest way, change the sql that your report is based on, add a extra field

eg

select field1, field2, mydate, format(mydate," dddd") as DateDay, field3
from mytable
etc

then u can use DateDay as the field that displays the day

or just format existing datefield if u want it in the same field
eg

format(mydate," mm/dd/yyyy dddd")

[pks00]

in fact, thinking about it, u might be able to format the field in your report to include dddd