RE: How can I do a compare EQ to the system date in a AS400 Query?

You can use CURRENT(DATE) to fetch the job date. If you're comparing against
a true date field, then that is all you need to do. Otherwise, you will have
to create a result field in order to format date for a valid comparison.

I provided an example of something similar to this in a discussion that took
place sometime in July. You should be able to find it if you search the
midrange-l archive.


Regards,

John Taylor
Canada

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Jim Cannon
> Sent: Thursday, August 10, 2000 11:15 AM
> To: MIDRANGE-L@midrange.com
> Subject: How can I do a compare EQ to the system date in a AS400 Query?
>
>
>
>
>
> Information Systems
> Arizona Biltmore Resort & Spa
> 602-954-2569
>
>
>
> +---
> | 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
+---