Convert to Date question 1

[kcsilentbob]

Running Crystal XI

I need to convert three fields into a single date field that can have a parameter run off of it.

Here is what i have:

I have three fields:

Table.BegMonth
Table.BegDay
Table.BegYear

I need to merge these three fields together for a field that can have a date parameter run as a range.

 

[kcsilentbob]

The three fields are in string format

 

[lbass]

You could create a formula:

cdate({Table.BegYear}+","+{Table.BegMonth}+","+{Table.BegDay})

-LB

 

[kcsilentbob]

Thanks...that did the trick