On 4/20/2015 6:33 PM, stinas...@yahoo.com [flexcoders] wrote: > Below is my code. is there something am doing wrong? Please help.
well first off you don't need the query-of-query, you can get what you want in one query. > WHERE datePaid <= <cfqueryparam cfsqltype="cf_sql_timestamp" > value="#parseDateTime(arguments.datePaid)#"> what's datePaid look like? parseDateTime only works with en_US locale date formats. in any case, have you tried testing this in plain cf first?