David Both are Date/Time Fields and radhika I did check regarding any NULL values in $Start_Date$, but there are none. Ankur
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Narayanan, Radhika Sent: 13 December 2006 15:21 To: arslist@ARSLIST.ORG Subject: Re: Date/Time in table field Qualification ** I think you'ld get that error whenever $Start_Date$ is NULL. You wouldn't get any error when $Start_Date$ has a valid date/time value. So, you'ld have to make sure that $Start_Date$ always has a value. If null, give it a default value like '1-Jan-1970'. (provided you're using this qualification directly in the Table Property-> Qualification) OR You may also get this error if you're building the qualification string dynamically using the EXTERNAL keyword. In that case you may want to use double-quotes around $Start_Date$. Thanks Radhika Direct : +44 20718 20262 Extn : 20262 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ankur Gulati Sent: 13 December, 2006 7:34 PM To: arslist@ARSLIST.ORG Subject: Re: Date/Time in table field Qualification ** Joe, Both are Date/Time fields. 'create_date' and $Start_Date$ Ankur On 12/13/06, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Ankur, Make sure you are not comparing a Date field to a Date/Time field... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: Ankur Gulati < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG Sent: Wednesday, December 13, 2006 7:25:37 AM Subject: Date/Time in table field Qualification ** Hi Listers, I am trying a basic qualification in the Table field 'create_date'<=$Start_Date$ both the fields are the Date/Time fields of a regular forms. when I run it it gives "ARERR [313] Data types are not appropriate for relational operation" but when I try 'create_date'<=$DATE$ it works fine, in this one is date/time and other is date field. I am clueless as what needs to be substituted for 'create_date'<=$Start_Date$ to work. I know this topic has been discussed lot of times in past, have gone through the archives but couldn't resolve it. Ankur ________________________________ Everyone is raving about the all-new Yahoo! Mail beta. <http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/m ailbeta> __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"