I set datebilled field as a datetime data type in MS SQL 2005
server and the form value of this field is "mmyy" (for example,
0107) instead of "mm-dd-yyyy".
Data in the database
I need to list all records which contains January 2007, so
the output will be 01-02-2007, 01-12-2007, 01-15-2007.
anyone can help me to wirte a query on this case? I cannot
think of manuplating the form variable in order to get the list.
<cfset form.dtbilled = "0107">
select dtbilled from aprtment where dtbilled =
'#form.dtbilled#' : if i use this query, it will bring up nothing.