Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Count( if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1), employee_id,0))
How can put this in Set analysis ?
Thx,
Hi try this:
count( {$<date_start = {>=date(vdateNum)}, date_etabl = {>=date(vdateNum), NULL}, date_branch = {>=date(vdateNum), NULL} >} employee_id)
Hi,
You can do this by using flags.
Make a flag in you script like:
if(date_start <= date(vdateNum), and (date_etabl > date(vdateNum) or ISNULL(date_etabl)=-1) and (date_branch > date(vdateNum) or ISNULL(date_etabl) =-1),1,0) as Flag
succes,
Halmar
Thanks !!