Help need in SQL(BO)

[prkr8]

I am calucating the Work duration time of start and completion Date,Means Work duration=work completion date-work start date.
if work completion date is NULL means work not completed , then work completion date has to replace with system date(Current date).
How we do that in BO
Thanks in advance.

 

[skrandel]

Build a variable.

=if IsNull(<completion date>) then CurrentDate() else <completion date>

Steve Krandel
VERITAS Software

 

[dbomrrsm]

Steve

Could you also use

CASE WHEN completiondate is null then currentdate
else completiondate
END

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

Sure.

Your solution works at in the universe. Mine is for the report.

I prefer to do things at the universe whenever possible.

Steve Krandel
VERITAS Software

 

[dbomrrsm]

Thanks for the clarification Steve

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[prkr8]

Thanks,it helps me a lot.