Formula in Running Total - year between 1 - 9999 error

[cboulier]

In Crystal 8.5 I created a formula to concatenate date fields I have available to create a "real" date field:

DateSerial ({demographics.dem_high_school_grad_year},{demographics.dem_high_school_grad_month},1)

This formula appears to work and give me a good date field (example: 3/1/2007)

I am then using a formula in a running total to find students who graduated in the past 12 months:

DateDiff ("d", {rpt_generic.date_2},{@HS Grad Date}) <= 365

The formula checks out but when I try to preview I get the "Dates must be between year 1 and 9999" error and it opens my original DateSerial formula.

It's been frustrating because that DateSerial formula seems to work until I use it in the running total formula so I am reaching out for help, thank!

 

[lbass]

Can one or both fields in the initial formula be null? If they can be, what would you like to happen?

-LB

 

[cboulier]

I suppose they could be on rare occasions (although they should not be).

If they were Null then I would just want them to default to a date in time that would not interfere with the calculation like '1/1/1900'