Calculate difference between 2 days

Wim Ardon

Hello!

I would like to print (in the dunning letter) the difference between 2 dates.

I've tried LD.QueryData("SELECT DATEDIFF(D,date1,date2)"), just subtracting date2 from date1 and Cint(GetData...) - Cint(GetData...)

However, no result!

Any Idea?

Best regards,
Wim Ardon
Asecom

Philipp Knecht

Hi Wim

If date1 and date2 are really dates then this should work basically.
If you already have the fields in the designer you also can use the System.DateTime. - Functions in VB.

hth

Wim Ardon

Hello Philipp,

Both dates are real dates; I've printed them and they showed (uun-editted) as dd-mm-yyyy hh:mm:ss.

What do you mean by System.DateTime. - Functions in VB?

Do you have a list of avaiable LD-functions?

I need the difference between the creationdate of the dunningwizard and the invoicedate....

I'm lost!

Hope you can help me!

Regards,
Wim