|
| |
|
|
cliffdeen
Posts: 155
Joined: 4/12/2004
From: Mckinney, TX
Status: offline
 |
Converting Dates to QTR's - 9/16/2004 17:04:34
Not sure if this the correct forum to post this problem too, but after several hours of trying to get the results from a SQL db I figured I would give it a shot.
What I am trying to do is convert dates from 12/12/2004 format to QTR format so the end result for the date example given would be 4 - 2004 - meaning the 4th QTR 2004. I have tried using the ACCESS db code of :
Expr1: "Q" & DatePart("q",[projectend],1,0) & "-" & DatePart("yyyy",[projectend])
which works great on a ACCESS DB, but the SQL does not seem to let me combine the two DatePart functions into one column. I can do two columns - 1 showing the QTR and the other showing the year, but I don't know how to combine the two columns into a third column or end result expresssion. I need the QTR-YEAR format to perform a retrieve record(s) by QTR/YR on a ASP page using the DRW with Search form criteria, but it doesn't seem to want to work with the SQL DB correctly either. Again everything works fine with ACCESS so it must be a syntax something.
Any ideas?
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
