Iso date format as400

March 17, , AM. All my answers were extracted from the "Big Dummy's Guide to the As" and I take no responsibility for any of them. Comment Post Cancel. Thanks Jamie. Last edited by bryce4president ; March 17, , AM. Originally posted by jamief View Post. It will take a number, such as the day of the month like the 9th, and display it as "09". The beauty about rpgiv and date handling is that if you have a complex statement to handle some sort of date manipulation, there's probably a very quick shortcut to it.

Procedure - Getdate you will need to remove the holiday logic For example:. It is generally considered good practice to always code factor-1 on date move operations. Keep in mind that the left-hand and right-hand side of EVAL expressions must be the same data type. Dates can be compared to each other without concern for the format. Note: Again, the exception to this rule is comparing two-digit year formats to four-digit formats. Because dates before or after are not supported with two-digit year formats, comparing or moving a four-digit year format outside of this range will cause unexpected results.

Elements from date or time fields month, seconds, etc. If date fields are used in both factor-1 and factor-2, it will calculate the duration between the two dates and update the result field.

The result field may be calculated as any one of the valid duration codes. For example, look at the following code:. Even though we added one month and then immediately subtracted one month from a date, the result is not the same as what we started with.

While not necessarily wrong, peculiarities like this should be understood before using this functionality. Following are some examples of how you can simplify previously mundane programming tasks. This used to involve a series of division statements first by 4, then by , then by with work fields to capture the remainders. Now it is as easy as checking the year for a valid date of February Determining the last calendar day of a month used to involve arrays containing the number of days in each month and a routine to check for leap year.

The first line of code sets the numeric field WorkDate to the first day of the month. The next line of code moves this to a date data-type field Date. The third line of code adds one month to Date to arrive at the first day of the next month. The last line subtracts one day from this date to arrive at the last day of YrMth. There are a number of ways to figure the day of week for a given date. The code required now is fairly straightforward to calculate the day-of-week for given date Date :.

ILE procedures allow you to bundle your code and create your own versions of built in functions. Instead of executing a subroutine or calling a separate program, ILE procedures can be called directly in expressions. The examples above could easily be re-coded so they may be execute like the following:. C if LeapYear C do something. For now, this is just to whet your appetite. These are the appropriate lengths for string representations for the value. Date strings A string representation of a date is a character or a Unicode graphic string that starts with a digit and has a length of at least 6 characters.

Trailing blanks can be included. Other formats do not have an abbreviation to be used by the CHAR function. Valid string formats for dates are listed in Table below.