Try this
SELECT AdINFO_Publication,
ADINFO_PUBLICATIONDATE_YEAR+ '-' +
ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear
FROM crAdInfo
AND ADINFO_PUBLICATIONDATE_YEAR+ '-' +
ADINFO_PUBLICATIONDATE_MONTH + '-01' BETWEEN
#dateformat(startdate,"yyyy-mm-dd")# AND
#dateformat(enddate,"yyyy-mm-dd")#
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 12, 2007 7:01 PM
> To: CF-Talk
> Subject: SQL Concat Issue
>
> I am probably being dense or showing my ignorance here, but I have a
> legacy database that I need to run a query on like the following. Can
> anyone tell me how I can achieve the following. Right now I am getting an
> error that PubYear is not a valid column. Thank you!
>
> SELECT AdINFO_Publication,
> ADINFO_PUBLICATIONDATE_YEAR+ '-' +
> ADINFO_PUBLICATIONDATE_MONTH + '-01' AS PubYear
> FROM crAdInfo
> AND PubYear BETWEEN #dateformat(startdate,"yyyy-mm-dd")#
AND
> #dateformat(enddate,"yyyy-mm-dd")#
>
> Any Help is appreciated. Thanks!
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290995
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
