CurrentDate in formula

[dmccallum]

I need to calculate the aging of some invoices. In my report I need to subtract Due_Date(a string) from CurrentDate(date of report) but every formula I try fusses that CurrentDate is not a string. How can I work around this?

 

[kenhamady]

To do date math you have to convert your string date to a true date. How you do this depends on what format your date string is stored in. See my FAQ in the general forum on common formulas. There is one that converts a string date to a true date. You can also try the DateValue() function. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.