johnhendy5
Posts: 12
|
| Posted: 12/16/2004, 3:19 AM |
|
Hi,
I am using a popuplist that contains 01 for January etc. I need to be able to search through my events dates to extract records for that month. My problem is that code charge is expecting a date but only getting a value of 01 for January. Does any one know of how you can get round this.
cheers
john
_________________
Thanks |
 |
 |
peterr
Posts: 5971
|
| Posted: 12/16/2004, 4:03 PM |
|
You may need to use an SQL statement that retrieves only the dates for some specific month, then test it with January like "WHERE function(my_date) = 1". You may need to refer to your database documentation to find the date/month functions.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
