Microsoft Office Forums - View Single Post - [Solved] Using DateDif Function

Thread: [Solved] Using DateDif Function

View Single Post

Old

03-14-2014, 08:47 AM

JulieS

JulieS is offline

JulieS uses Windows 7 64bit

Windows 7 64bit JulieS uses Office 2013

JulieS uses Office 2013

Office 2013

Expert

Join Date: Dec 2011

Location: New England

Posts: 1,693

JulieS will become famous soon enough

Default

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))

Reply With Quote