Error when converting numeric to date

[amih]

A newbie here:

I am trying to convert a numeric field into a date field. I created individual formulas for the month, day, year. When I go to combine those results, I receive the error, 'The string is non-numeric"


Here's what I have:
The formulas for month, day, year follow this format: ToText ({LACTG04.AG4_TRANS_RELS_DAT})[8 to 9]

The formula to combine look like this:
Date(ToNumber({@month}),ToNumber({@DAY}),ToNumber({@year}))

What am I doing wrong???

Any assistance is greatly appreciated.

 

[dgillz]

What format if your field in? If it is an 8 digit integer in a YYYYMMDD format, download NumberToDate() from the crystal decisions website, and convert your number to a date with this function. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Ngolem]

Your formula is in the wrong order///it must be in year,month,day order

Date(ToNumber({@year}),ToNumber({@month}),ToNumber({@DAY})) Jim Broadbent