Add an Active Link - If Dates are Null then set the dates to > "01/01/1970" May need a hidden date field to make this look pretty.
Dale Jones DCS [EMAIL PROTECTED] http://www.dcshq.com/ Remedy Consulting Raleigh, NC 919-523-6034 From: Sergio Tomillero Sent: Fri 11/14/2008 6:36 AM To: arslist@ARSLIST.ORG Subject: Date/Time field in Table Qualification Hello people, I am trying to indicate a qualification in a table field, limiting the result at the value of two Date/Time fields. The problem is if I do not indicate any value in the date/time fields, the ARERR [313] error appears, with the next message: 'Data types are not appropiate for relational operations'. I have realized that Date/Time fields do not let to compare their value with NULL in Table fields Qualification, neither with "". Any idea? Thanks in advance, Sergio Tomillero -- View this message in context: http://www.nabble.com/Date-Time-field-in-Table-Qualification-tp20498771p20498771.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"