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: [email protected] 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 < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]> To: [email protected] 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/mailbeta> __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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
