Hi
I am struggling with a DateDif function. I want to be able to identify those tasks that are scheduled to finish within 3 days of the current date. Here is what I have tried so far:

IIf(Date()-[Finish]>"0" And Date()-[Finish]<="3","TRUE","FALSE")

IIf(DateDif("d",[Finish],Date())>"0" AND DateDif("d",[Finish],Date())<="3","TRUE","FALSE")



However neither works. I am sure I am close but cant see the issue.

Any help appreciated.

Thanks
Tony

Hi Tony,

The Project function is DateDiff and I would use [Current Date] instead of Date().

Try:
IIf(DateDiff("d",[Finish],[Current Date])>0 And DateDiff("d",[Finish],[Current Date])<=3,True,False) in a flag field

Hi Julie
Many thanks for your prompt response (yes I did spell the Function name wrong :-)).
I ended up using this formula in the end but will also try your solution:

IIf([Finish]>Date(),IIf([Finish]-Date()<=3,"TRUE","FALSE"),"NA")

Edit:
I modified your solution in an attempt to ignore those tasks that were complete but the edit does not work, any ideas?

IIf([Status]="Complete","",IIf(DateDiff("d",[Finish],[Current Date])>0 And DateDiff("d",[Finish],[Current Date])<=3,True,False))

Thanks

Tony

The status field is a number field to the best of my knowledge. Try using % Complete. The formula below works in a Text field (not a flag field)

IIf([% Complete]=100," ",IIf(DateDiff("d",[Finish],[Current Date])>0 And DateDiff("d",[Finish],[Current Date])<=3,True,False))

Hi Julie

Thanks for the feedback. Unfortunately this formula does not appear to work. For example I have a task that is due to finish on 19 March and it is not being flagged at all.

Edit: Sorted - needed the True and False in quotes then it works fine.

Thanks Julie.

Tony

Great. Glad you have it worked out. I think when I tested I just saw the -1 and 0 and forgot to switch it out.