Using DateDif Function

		Microsoft Office Forums > Microsoft Office > Project
Using DateDif Function

FAQ

Thread Tools

Display Modes

03-13-2014, 10:14 AM

JulieS

Windows 7 64bit Using DateDif Function

Office 2013

Expert

Join Date: Dec 2011

Location: New England

Posts: 1,693

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
IF function	msheyworth	Excel	2	03-28-2013 02:15 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM
Help with DATEDIF Formula	caz46	Excel	7	01-12-2012 08:46 AM
if function help	jim831	Excel	2	10-29-2010 07:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:53 AM.