Hi Dale, Thanks for your answer. I have done it so and it works as desired.
Kind regards, Sergio Tomillero Dale Jones wrote: > > 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: [email protected] > 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" > > -- View this message in context: http://www.nabble.com/Date-Time-field-in-Table-Qualification-tp20498771p20500509.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"
