Number of Days

[iamadolfan]

I have a formula field and I want to get the difference in days from that day to the Invoice date. Any ideas? I keep getting an Error that is is expecting a date in the formula field.

Here is what I AM USING:

{View_test.InvoiceDate} - {@Promise Date}

 

[Turkbear]

Hi,
What Type/Contents is {@Promise Date}





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[iamadolfan]

It is a Date Field

 

[Turkbear]

Hi,
If both are true DATE types try Crystal's DateDiff function
in a formula like:
@HowManyDays

Local NumberVar Days;
Days := DateDiff ("d",{@Promise Date},{View_test.InvoiceDate})

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

If they were both date fields, you wouldn't get that error, so trying wrapping the formula in date() and see if that resolves the issue. If it doesn't, then right click on the fields->browse field->and note the datatype shown at the top and report back.

-LB