How to calculate difference of two dates when one date is selected from the interface???

[#1]

Hi all,

I want to calculate difference of two dates when the last date is selected from the interface..

Ex: Period= Date1-Date2

(Date1 is selected from the interface and Date2 is the invoice date)

How can I do this?

Please help me on this issue!!!

Thanks and Regards,

Nilupa

[#2]

Hi,

You can define a variable (vDate1) - Calendar format or Input table, having date format.

In the expression,

Period=vDate1-Date2

It should work.

Happy Thoughts

[#3]

nilupaboralessa , I think attached doccument will help you.

Please look into expression used in front end for date difference.

Regards,

Dushyant

[#4]

Thank you both 🙂