AW: [firebird-support] view and computation

Hello Markus, Thank you, exactly what I'm looking for! Best regards. Olaf > ** > 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((curren

Re: [firebird-support] view and computation

On Wed, Jul 31, 2013 at 9:31 AM, Olaf Kluge wrote: > ** > 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.zah

[firebird-support] view and computation

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 pay