On Thu, 11 Dec 2003 12:56:23 -0500, Steve Breen wrote: >Currently we are tracking and storing the date (12/10/03) in the table for each record, but not the day of the week. Now it seems that we have to track the day of the week. Monday, Tuesday ect:
Steve, You don't need to store it, you can compute it easily in reports and views and computed variables in forms. (TDWK(datecolumn)) is the "text day of week" (IDWK(datecolumn)) is the "integer day of week" (FORMAT(datecolumn,'WWW')) is the abbreviation for the weekday (FORMAT(datecolumn,'WWW MM/DD/YYY')) gives you the abbreviation for the weekday and also the traditional view of the date. If you want to "group by" days of the week, you could either add a computed column or create a view with a column based on the expression. I would recommend IDWK for the computed column, since the abbreviations sort alphabetically, not chronologically, but the IDWK sorts by day. Bill
