subtract dates with crystal report 8.5

[federicogonzale]

I need to obtain the diference betwen a field date and a field date that I pass to crystal report. But when I execute the program I receive an error, but when I used currentdate-mydate I don't have problem. the format of field date is correct.


I need an example please.

[VB4fun]

not sure I understand....

diference betwen a field date and a field date that I pass to crystal report

but if you are trying to find the difference between two dates ON the report, check the following...

http://www.vbforums.com/showthread.p...hreadid=258020

where "n" = minutes, "h" = hours, "d" = days, "m" = months

otherwise, if you are passing the difference itself, to the report, you could use the DateDiff function in Vb..

http://www.vbforums.com/showthread.p...light=datediff

Hope that helps