expression help

[Ravi Kumar]

hello all,

=IIf(Int([Due Date])<Int(Date())&IsEmpty(Int([Completed Date]),"Overdue")

I need to modify this to get the below result(I am not getting how to use of not null)
1. if due date is lesser than today's date or if completion date is empty then it should show overdue.
2. or if completion date is full then it should not show anything.

please help me.

 

[Minty]

I would do the test for completion date first, (Air Code not tested but should work)

IIf ([Completed date] Is Not Null,"", IIf ([Due Date] < Date, "Overdue",""))

 

[Gasman]

=IIf(Int([Due Date])<Int(Date()) OR (NZ([Completed Date],0)=0),"Overdue","")

NB I saw Minty's post but thought you could still use an OR ?

 

[Ravi Kumar]

I would do the test for completion date first, (Air Code not tested but should work)

IIf ([Completed date] Is Not Null,"", IIf ([Due Date] < Date, "Overdue",""))

thank you, but #NAME? error is coming

 

[Ravi Kumar]

=IIf(Int([Due Date])<Int(Date()) OR (NZ([Completed Date],0)=0),"Overdue","")

NB I saw Minty's post but thought you could still use an OR ?

thank you, but all rows are now showing as over due , even of completed date is empty.

 

[Ravi Kumar]

is there any more details required , please tell me?

 

[Gasman]

hello all,

=IIf(Int([Due Date])<Int(Date())&IsEmpty(Int([Completed Date]),"Overdue")

I need to modify this to get the below result(I am not getting how to use of not null)
1. if due date is lesser than today's date or if completion date is empty then it should show overdue.
2. or if completion date is full then it should not show anything.

please help me.

 

[Minty]

I've checked the syntax and mine is syntactically correct, do you have some sample data you could upload?

 

[Ravi Kumar]

I've checked the syntax and mine is syntactically correct, do you have some sample data you could upload?

sure 5 mins

 

[onur_can]

it should be according to the conditions you describe.

=IIf(IsNull([Due Date])<(Date()) Or IsNull([Completed Date]);"Overdue";"")