Question
TimeStamp: Coldfusion V MSSQL
I've got a mssql database with records that have been
timestamped using coldfusions #now()#.
How do I go about running a cfquery to get the last 12 months of records???
In other circumstances the following statement would suffice
WHERE entryDate >= DATEADD (yyyy , -1, GETDATE()
Not sure how to tackle this one.
How do I go about running a cfquery to get the last 12 months of records???
In other circumstances the following statement would suffice
WHERE entryDate >= DATEADD (yyyy , -1, GETDATE()
Not sure how to tackle this one.
AdChoices