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]