Comparing dates for a Crystal 7.0 Report

[msloan]

Hello,

I am trying to determine the number of days between two dates. The two dates are being pulled from a database table.

for example:
tblProcurement.fldProcurementReqRcvdDate is the from date
tblProcurement.fldProcurementSentToFMODate is the to date
so:
if tblProcurement.fldProcurementReqRcvdDate = 05/31/2001
and
if tblProcurement.fldProcurementSentToFMODate = 06/03/2001
I would expect to see 3 as a return value.

This is my first attempt at working with Crystal Reports and I am not too familiar with all the features. I have tried creating a formula, and a range, and some other things, but nothing really seems to work.

Any suggestions are greatly appreciated.

Thanks in advance,

Matt

 

[tss450]

You can just subtract the two dates for the gross difference.

I believe KenHamandy has posted a helpful FAQ with formulas for date diffing. i.e business days, etc.

 

[FoxG]

Hi,

just create a formula like...

{date1} - {date2}


Geoff

 

[msloan]

yes Geoff,

I did this, and it doesn't appear to work

Matt

 

[FoxG]

Are your dates actually held as string fields ?

If so you will need to convert from text to date format with the function date(ccyy,mm,dd) first

Geoff

 

[msloan]

The fields within the source table are defined at datetime - do these need to be converted in any way?

Matt