is empty

[agaperrk]

I have a calc that is looking at one field. It is a date field.

The calc field will calc the days after the last date and put a return of "eligible".

Everything works right except for the ones that have no date in them.

My Calc

Case ( Get ( CurrentDate) - (Last Walk Worked Date) > 180;"Walk Eligible";"" )

if the last walk worked field is blank then it needs to reference OriginalWalkdate field.

So I get the first calc right and if the Last walk worked field is blank then it returns a blank.

Is there a way for it to look at the different field if the primary field is blank.

Thanks in advance.

Randy

[Ocean West]

Try this:

Let ( [



_cDate =  Get ( CurrentDate);

_theDate = Case( IsEmpty ( Last Walk Worked Date ) ; OriginalWalkdate ; Last Walk Worked Date )



] ;



 Case ( ( _cDate -  _theDate ) > 180; "Walk Eligible" ; "" )

)

[agaperrk]

it was perfect Thank you so much.