Comparing dates from different fields

[tj007]

Hi I am tying to compare dates from two fields I would like to show all records that have a INREF_PODATE that is greater than the INV_DATE. I am trying to show when payments were made before an invoice was received.


{invoice_podate.INV_DATE} >={invoice_podate.NREF_PODATE}

 

[Madawc]

In Crystal 8.5, just put a test in your report selection formula. (The one you show is the opposite of the one you describe, though.)

Alternatively you can set a suppression formula in your detail section and prevent records being shown if they have the wrong date.

With dates, you also need to make allowance for one date or both being null.

Madawc Williams
East Anglia, Great Britain

 

[tj007]

I have supressed other columns, however what is the formula for showing all records for {invoice_podate.INV_DATE}column which comes before >={invoice_podate.NREF_PODATE} column for the same record?

 

[tj007]

Do I need to convert the date field to a string then do a comparison?

 

[Madawc]

If the field is not defined as a date, you'll need to convert it. See the CDate (string) command.

Madawc Williams
East Anglia, Great Britain

 

[tj007]

Thank you I changed the date to a string and I was able to obtain the correct information.