Re: today's date in WRKQRY

[Jerry Draper <midrangel@xxxxxxxxxxxxx>]

Great link!!!!

J

On 2/12/2024 2:14 PM, Michael Mayer wrote:
> Jerry, here's something to keep handy as well.
> https://www.ibm.com/support/pages/using-currentdate-select-records-using-query400
>
>
> Respectfully,
> Michael Mayer
> IBM i on Power System Admin
> ERMCO-ECI
> 2225 Industrial Rd
> Dyersburg, Tennessee 38024
> Office and OnCall: 731.676.4318
> Cell: 518.641.8906
> Email:michael.mayer@xxxxxxxxxxxxx
> https://www.ermco-eci.com    
> IBM i Personal Blog:https://ibmireference.blogspot.com            
> "Success is not final. Failure is not fatal. It is the courage to continue that counts".
>
>
>        
>
>
> Today's Topics:
>
>     1. RE: today's date in WRKQRY (Sizer, Joseph via MIDRANGE-L)
>
> message: 1
> date: Mon, 12 Feb 2024 19:28:53 +0000
> from: "Sizer, Joseph via MIDRANGE-L"<midrange-l@xxxxxxxxxxxxxxxxxx>
> subject: RE: today's date in WRKQRY
>
> In Define result fields
>
> Field           Expression
> TODAY       current(date)