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]> 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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
