Date issues

[kcsilentbob]

I have three fields:

Table.Mo
Table.Da
Table.Yr

Basically it is the date broken into 3 seperate fields. I need to combine those fields into a workable date field for counting days.

I am running crystal XI.

Thanks

 

[lbass]

Assuming these are number fields, you should be able to use:

date({table.yr},{table.mo},{table.da})

...to get the date. Not sure what you have to count...

-LB

 

[kcsilentbob]

I am getting a too many arguments when I try to use that date function.

 

[lbass]

Well, there are not too many arguments, so I think you need to check the datatype of each field and report back. You can either note the datatype in the tool tip when you run the mouse over the fields on your report, or you can right click on the field and choose browse.

It would also help to see some sample data from each field.

-LB