Problem solve Get help with specific problems with your technologies, process and projects.

Convert CYMD dates to YYMD

Here's a strategy for converting CYMD dates to YYMD in queries.

I've seen a lot of strategies for converting CYMD dates to YYMD in queries, but I don't remember this one:

YYMD = CYMD + 19000000

To get the month, you can use YYM = YYMD / 100 (and be sure to specify 6.0) for the definition.

Dig Deeper on iSeries CL programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.