Crystal Reports Date Conversion

Artereis

My company runs a set of reports through an old as dirt Crystal scheduler program based on information in our AS/400 system.

The monthly reports have parameter fields that currently need to be updated in the scheduler monthly due to the date format used in our AS/400 system. The scheduler allows the use of dynamic dates that our output in a typical serial format: (yyyy, mm, dd).

The AS/400 date format is CYYMMDD. Currently, to set up the dates for June, we have to go into the scheduler monthly and enter the numbers 1100601 and 1100630 in the FromDate and ToDate fields.

I would like to automate this, but I'm having an issue with the syntax for the functions I need to use to do the conversion in Crystal. The selection criteria for the report needs to remain in the AS/400 date format, so what I would like to do is create two formula fields that convert the parameter field serial dates into AS/400 dates.

Any advice?

Fields:

{?From Date}
{?To Date}
{@ConvFrom}
{@ConvTo}
{AS/400 Field}