|
Thanks Art. This one I posted for an Ex-coworker. I myself have no date formats stored in my database, so I had no idea, but was curious as to the answer. This answer seems straight forward and I will pass it on to my friend in need. Thanks again. ----- Original Message ----- From: Art Tostaine, Jr. <art@link400.com> To: <MIDRANGE-L@midrange.com> Sent: Friday, April 30, 1999 7:37 PM Subject: RE: Ldate and opnqryf question > I use this for my QRYSLT when using a field DATEL from my database file and &DATEPARM from CLP: > > QRYSLT('DATEL *EQ "' *CAT &DATEPARM *TCAT '"') > > I prefer the double-quote over multiple single quotes (ticks) > > BTW, a fellow programmer who came out of Cittone Institute here in NJ was the first one to use the > "tick". I think it sounds nuts to say "tick". He also says "Splat" for asterisk! > > > Art Tostaine, Jr. > CCA, Inc. > Parlin, NJ 08859 > > > > -----Original Message----- > > From: owner-midrange-l@midrange.com > > [mailto:owner-midrange-l@midrange.com]On Behalf Of Buck Calabro > > Sent: Friday, April 30, 1999 5:49 PM > > To: 'MIDRANGE-L@midrange.com' > > Subject: RE: Ldate and opnqryf question > > > > > > OPNQRYF FILE((PROMAS)) QRYSLT('PROMASDATE *GE ''1999-01-01''') > > > > I used all single tick marks - no double quotes. > > > > Buck Calabro > > > > > -----Original Message----- > > > From: Wayne Achenbaum > > > Sent: Friday, April 30, 1999 1:28 PM > > > To: MIDRANGE-L@midrange.com > > > Subject: Ldate and opnqryf question > > > > > > Does anyone know how to compare a program variable against > > a physicla > > > file Ldate field(i.e. *iso)? TIA > > +--- > > | This is the Midrange System Mailing List! > > | To submit a new message, send your mail to MIDRANGE-L@midrange.com. > > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. > > | To unsubscribe from this list send email to > > MIDRANGE-L-UNSUB@midrange.com. > > | Questions should be directed to the list owner/operator: > > david@midrange.com > > +--- > > > > +--- > | This is the Midrange System Mailing List! > | To submit a new message, send your mail to MIDRANGE-L@midrange.com. > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. > | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: david@midrange.com > +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.