Thanks, Albert. That does exactly what I need plus it has the added bonus of being shorter. :-)
Thanks again. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: Albert Berry <[email protected]> To: [email protected] (RBASE-L Mailing List), Date: 02/24/2015 12:33 PM Subject: [RBASE-L] - Re: FORMAT function to display day of week Sent by: [email protected] TDWK(Date) Albert On 2/24/2015 10:23 AM, [email protected] wrote: I would like to display the text day of the week based on a date for a report. I have tried the FORMAT function but I'm apparently doing something not quite right. Here's an example of the results I'm getting: SELECT DAY_DATE,(IDWK(DAY_DATE)),(FORMAT(DAY_DATE,'WWW+')) FROM LKUPDATE WHERE DAY_DATE BETWEEN 2/1/2015 AND 2/7/2015 DAY_DATE (IDWK(DAY_ (FORMAT(DAY_DAT ---------- ---------- --------------- 02/01/2015 7 02/02/2015 1 02/03/2015 2 02/04/2015 3 02/05/2015 4 02/06/2015 5 02/07/2015 6 What am I missing? Thanks. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- A democracy ..." can only exist until the majority discovers it can vote itself largess out of the public treasury." Attributed to Alexander Fraser Tytler 1747-1813 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
