[AccessD] OT: SQL SERVER Format Date

Millard, Paul --- Sr. Developer Analyst ---WGO Paul.Millard at freight.fedex.com
Thu Apr 15 17:30:16 CDT 2004


Hi,

I know this isn't the right forum to ask but I need help formatting date from the SQL Server default output into "mm/dd".  The query results are reported in an asp page.

Thanks in advance,
Paul Millard


Here is my query and results....

----query----
set 
datefirst 1 
select top 13 
Week = (DateAdd(day, (-1 * datepart(dw, t1.ReqEntryDate)) + 1, t1.ReqEntryDate))
from tblPrFieldSales t1 where t1.ReqEntryDate >= '3/1/2004' 
order by Week DESC   

----results----
2004-04-12 00:00:00.000
2004-04-12 00:00:00.000
2004-04-12 00:00:00.000
2004-04-12 00:00:00.000

----ideal results----
04/12
04/12...
 


**********************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
****************************************************************




More information about the AccessD mailing list