Show a date as day name

[jk12]

Hi again, my problem is that on a report I have a row of dates i.e. 10/10/2006, 11/10/2006 etc. However, people would prefer to see Monday, Tuesday etc. Is there a way to show the date as the day name. The date fields are all based on the Date() expression then +1, +2 etc so are always changing.

Thanks

 

[PeterF]

Use the format function to show the day, for example:

=format(date(),"DDDD MM/DD/YYYY")
or
=format([yourfieldname],"DDDD MM/DD/YYYY")
or
=format(date(),"DDDD MMMM YYYY")

 

[jk12]

Thanks thats it works fine now. Hopefully people will be a bit more satisfied now!