Hi everyone:
Does anyone know of a simple method to convert a date/time to its corresponding Unix time via the client? I want to set a field using direct SQL. I have a date/time field on a form, and I want to set another field with the number of requests that were submitted after a date selected by the user in the date/time field. The problem is, the Create Date is a long integer field in the database, not date/time. So passing the contents of the date/time field to the SQL query is invalid. So to summarize, I have a form with a date/time field, a character field, and a button. I want the user to choose a date and time in the date/time field. He then clicks the button. The system is then to populate the character field with the number of requests that have been opened on or after the date the user specified in the date/time. The issue, however, is that the date/time must be converted to Unix time before it is passed to the direct SQL in order to work. Any ideas? I've thought about pushing the date and time to the database as a junk value on a junk form and then directly retrieving the result via direct SQL, but that method is awfully weighty for something that should be rather simple. I would think there is some function that can do this on-the-fly. Norm _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
