Date Functions in SAP Crystal REports 2016

[former_member1006930]

Hi, I'd like to create formula in workshop that takes a date from record and adds a number of days (Credit Terms we have in record) to the date to output a date. How do I do that? Trying to calculate due date of invoice.

[abhilash_kumar]

Hi,

You could create a formula that looks like this:

DateAdd("d", 1, {datefield})

You can replace the "1" with a database field if the days to add is also available as a field,

-Abhilash