AS/400 Date Format

Data selection criteria to pull last months information

I run a series of queries at the beginning of each month to pull transactions from the previous month.  Currently I am setting the date range for the julian dates.  I would like to automate this series of queries and need a way to automate the data selection criteria so it will automatically pull...

converting date + time into timestamp

Hi I'm trying to convert date+time into timestamp n get thousands of error... my code is as below c     FMTIMCHAR     ifeq      '*ALL' Eval      FMTIMCHAR = '0000' C                   Eval      T1 = %subst(fmTIMCHAR:1:2) + ':' + ...

AS/400 date format

How do format a date field to MM/DD/YYYY?

AS/400 Query - Current date -1

Is there a quick and easy way to calculate yesterdays date by using "Define result fields"

Converting Julian date to Gregorian in WrkQry

I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

Last Day of Month

Is there a routine to arrive at the exact last day of the month? *Month doesn't do it.

Date calculation question

I have a date manipulation question on the AS/400. I need to be able to take whatever date the system date is and calculate the next Friday date and output that to the LDA in the format MMDDYY. It needs to have the leading zero for the single digit months AND it is just a 2-digit year. I swear I...