How about this:
USE arsystem DECLARE @timestamp AS BIGINT SET @timestamp = DATEDIFF(s, '1/1/1970',GETUTCDATE()) SELECT * FROM your_form_name_here WHERE (create_date >= (@timestamp - 2*60*60)) AND ((create_date - 3600) > date_received The key here is that the number stored in the database is not a datetime but rather an integer. So the only really complicated part is creating an MS SQL equivalent to the Remedy $TIMESTAMP$. Norm __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
