I am building an events calendar and want to pull all objects from the CODB that are scheduled for the current month. I have set up searchable property called dtEventDate. The property is set up as a DateTime type. I have created a variable that holds the first day (startMonth) of the month and another for the last day of the month endMonth). I am trying to build SQL that will retrieve all of event objects whose dtEvenDate is between startMonth and endMonth. It never returns any records. In Ben Forta's book (page157), he states that DateTime properties are stored as a string of "mm/dd/yyyy". When I look at the properties table, the property appears to be the number of days since 1/1/90. How do I set up a valid SQL query to return the events that are scheduled month. (I have tried creating the variables using the CreateODBC function, setting up the variables as strings using the DateFormat function). ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
