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

Thread: [Solved] Using DateDif Function

View Single Post

Old

03-13-2014, 10:14 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

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

Reply With Quote