Regarding this problem, you can use the expression below in a calculated field in a query:
DayAndDate = Format (Date(), "dddd, mmm d, yyyy")
If the current day is 07/23/2010. After this operation, the date will be converted to the style as "Friday, July 23, 2010". Anyway, if you want to format the date as wanted, proceed in this way.