Date Diff

Sweetha

Dear All,

i want to get a date diff between 2 fields.if the field actfinsh is empty,it should take current date ,in actuate i did like this.i made one computed field delay as

delay=DATEDIFF("d", workorder.targcompdate,IsNull( workorder.actfinish,getdate())).

In birt is there any function to find out..

more over i have to put the actfinish also as one field in my report.

Thanks

Sweetha

Got It By Selecting In Fetch