Hello,



in a view, the following expression is possible :
.(a.eingangsdatum+coalesce(c.zahldauer,0)) as FAE,.

But how can I take the current date in relation? For example:

cast((current_date - (a.eingangsdatum+coalesce(c.zahldauer,0))) as integer)
as FIN

I would like to calculate when the payment will be due.



Thank you.



Best regards.



Olaf







[Non-text portions of this message have been removed]