Well...this isn't what your asking for...but it's one way to get it done...if you create a hidden table field with a single column...set it's qualification to something like 'Create Date' >= $Date/Time Field$ and on button press you could refresh this hidden table and then either use $LASTCOUNT$ or COLCOUNT($ColumnInYourTable$) to get the count of the records...it's not as 'clean' as select count(*) but it should produce the same results
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Monday, June 04, 2007 12:45 PM To: arslist@ARSLIST.ORG Subject: Easy Unix Time Conversion ** 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 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
