Subject view and computation
Author Olaf Kluge

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.


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