jtarabay
Posts: 13
|
| Posted: 09/21/2006, 6:39 AM |
|
Could someone tell me how to search by month only. The DBFormat is mm/dd/yyyy, I just need to search by month(mm) when I set the format as mm and the DBFormat as mm/dd/yyyy and then try to search, I get the error:
The value in field s_Date_of_Birth is not valid. Use the following format: mm.
Thanks for any help you can provide.
JT
|
 |
 |
jtarabay
Posts: 13
|
| Posted: 09/22/2006, 8:38 AM |
|
This is the search code, can anyone tell me why this would give me the above error, even though when I do a search, I am using the mm format, such as 05
ComponentName = "ConsumersSearch"
Method = IIf(FormSubmitted, ccsPost, ccsGet)
Set s_Date_of_Birth = CCCreateControl(ccsTextBox, "s_Date_of_Birth", Empty, ccsDate, Array("mm"), CCGetRequestParam("s_Date_of_Birth", Method))
|
|
|
|
|
