Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-13-2014, 06:32 AM
OTPM OTPM is offline Using DateDif Function Windows 7 32bit Using DateDif Function Office 2010 32bit
Expert
Using DateDif Function
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default Using DateDif Function

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
Reply With Quote
 



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
Using DateDif Function IF function msheyworth Excel 2 03-28-2013 02:15 AM
Using DateDif Function Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
Using DateDif Function 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 01:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft