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
