Adding days to Date field

graemejenkins

Hi All,

I have a date field * INVC_HEADER['INVC_NUMBER'] * to which I need to add a value to, which is converted from another field into a value * (if (INVC_HEADER['TERM_CODE']='NET 7') then Value :='7' else * etc

I've tried all manor of different methods but all return with 30/12/1899

Any thoughts or ideas?

I'm using ReportBuilder as part of Quantum from Component Control - who are refusing to help...

Thanks!

Graeme.

graemejenkins

Don't worry.. worked it out in the end.

Add Calc fields:

• varTermsDays (Integer) OnCalc:

if (INVC_HEADER['TERM_CODE']='NET 7') then Value :='7'
else
etc

• varDatetoInt (Integer)

Use date field from Quantum, but set field type to Integer

• varDueDateInt (Integer) OnCalc:


Value := varDatetoInt.value + varTermsDays.value;


• varDueDate


Value := varDueDateInt.value

But set field type to dtDate

Thanks me. Cheers