How can I pull all records where date = this month. this is what I have and
it is not working?

Which month is it

<cfset thismonth = #now()#>

And then I query using this query .
select * from tablename
where completed = 1
and date = #DatePart("m", thismonth)#
order by date,time

There are 7 record but it pulls 0 records

What am I doing wrong?
Thx ,
JT
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to