<div>
Also, what format is the date in yor file? &nbsp;Is it a DATE field, a numeric field, or a character field? &nbsp;If numeric or character, how is the date formatted (give an example, please).<br />
<br />
The current() function returns a value in DATE, TIME, TIMESTAMP format, depending on the parameter you select.<br />
<br />
If your date is stored in DATE format, you can you can just compare to current(date). &nbsp;If it is in numeric or character format, you have to do a bit more work to get both the system date that you get from current(). &nbsp;In Barry's example above, he uses the CHAR function to convert the TIMESTAMP returned by current() to CHAR format. &nbsp;Dates stored in numeric format are even trickier, and generally require that you convert the numeric date into DATE format using a combination of DIGITS, concatenation, and DATE functions.<br />
<br />
If you'll post back with the date format that you need to compare, we can give you a specific example.<br />
<br />
- Gary Patterson
</div>


<div>
Guys thank you so very much! &nbsp;I got it now just needed you to remind me where to begin. &nbsp;By the way the dates are defined in DATE format so I was able to use both your examples to get what I needed. &nbsp;You two ROCK!!!!!!! 
</div>


<div>
In that case, current(DATE) was the answer you needed, so points to Barry, please.<br />
<br />
- Gary
</div>


<div>
Duely noted. &nbsp;Thank you both for taking the time to answer my putzy question. &nbsp;And Barry thank you for giving me the answer I needed. 
</div>


<div>
You're welcome. No such thing as a putzy question.<br />
Take care<br />
Barry
</div>


<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


<div>
<div class="content wysiwyg-content">
This is such a beginners question that I'm almost ashamed to ask but I'm gonna anyway. &nbsp;I am building a query using wrkqry in an AS/400 environment. &nbsp;I want to check a file date against the current system date. &nbsp;Does wrkqry recognize the system date? &nbsp;If so what do I call it in my &quot;Values&quot; field.<br />
<br />
Thanks All. &nbsp; &nbsp;
</div>
</div>


This is such a beginners question that I'm almost ashamed to ask but I'm gonna anyway.  I am building a query using wrkqry in an AS/400 environment.  I want to check a file date against the current system date.  Does wrkqry recognize the system date?  If so what do I call it in my "Values" field.

Thanks All.    

how to default current date when selecting records in wrkqry

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.