Subtract 1 "Date and Time" field from another "Date and Time&quot 1

[DianaStewart]

Is this possible?

On my report I have a field named Date1 and a second field which is Date2. Both these fields are of Date and Time data types.

Is there a way to subtract the one from the other?

Date1 - Date2 =

 

[lyanch]

Click on the "FAQ" tab. Howard Hammerman has a FAQ on exactly how to do this.

 

[dgillz]

See the CR helpscreens on the DateDiff() function. If you are using CR version 7 or older, you will not have the datediff() function, but you van go to Crystal Decisions website and download it. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com