Re: What is wrong with this %DATE function

[Charles Wilt <charles.wilt@xxxxxxxxx>]

If then input value is alpha, then date seperators are required.

Also, *USA is mm/dd/yyyy. yyyy-mm-dd is *ISO.

Charles

On Fri, Mar 11, 2016 at 10:33 AM, Vidal, Peter <Peter.Vidal@xxxxxxxxxxxxxxx>
wrote:

> Hi list!
>
> DPA_F55EOPR       S             10A   Inz('20110101  ')
> DMinDteCR         S               D   DatFMT(*USA)
>
>  /free
>
>    MinDteCR = %Date((PA_F55EOPR):*USA);
>
>    *inlr = *on;
>
>  /end-free
>
> It is blowing up with this error: Date, Time or Timestamp value is not
> valid (C G D F).
>
> TIA,
> Peter Vidal
> Developer AS400
> P: 800-808-1902, x137210 | F: 813-884-2847
> 9119 Corporate Lake Dr., Suite 300 | Tampa, FL 33634 | www.carecentrix.com
> <http://www.carecentrix.com/>
> [cid:image001.png@01D17B81.7B648D40]
>
>
> ________________________________
> This communication is intended only for the use of the individual or
> entity named as the addressee. It may contain information which is
> privileged and/or confidential under applicable law. If you are not the
> intended recipient or such recipient's employee or agent, you are hereby
> notified that any dissemination, copy or disclosure of this communication
> is strictly prohibited. If you have received this communication in error,
> please immediately notify CareCentrix Compliance Hot Line at (877)
> 848-8229 and notify the sender by electronic mail. Please expunge this
> communication without making any copies. Thank you for your cooperation.
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.