Skip to Content
avatar image
Former Member

Aging formula in days crystal reports

Hello,

I need to create a formula in crystal to show date difference in days as follows:

Current system date - Entry date (a field in the database)

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 07, 2016 at 02:30 PM

    Hi Med,

    Create a formula with this code:

    DateDiff('d', {Entry Date}, CurrentDate)

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded