Trying to find difference between 2 dates

[m3gd04]

Hello All,

Simple problem that I hope you could assist. In a report, I have 2 fields that are dates but are "dimensions" rather than "measures" . I'm simply trying to find the difference between the two dates, quoted in "days". They are as follows:

Field one = Case Date
Field two = Birthdate

I guess I'm trying to find out how I can convert the "case date" and "Birthdate" into integers, and then find solution as "days"

ie..

Case Date Birthdate Days in between ??
11/15/05 09/15/05 61

Any help would be greatly appreciated.

thanks

 

[MisterMo]

depending on your version of CR, I think that datediff should do the trick here

datediff("d", {case date},{Birthdate})

Mo