Bill, I appreciate this information. How would you include this as an expression in a report?
I was thinking in simple terms: day = (TDWK(datecolumn)) But I have my doubts that this will work. I believe I am thinking in the wrong direction here Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Downall Sent: Thursday, December 11, 2003 12:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Day of week insert 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
