post #1 of 1
Thread Starter 
Scenario: I want a column to simply display yes or no if the difference between the date in one column is greater than 30 days from todays date.

This is in Sharepoint 2010 if it makes a difference.

All I've got so far is this, here is where I'd like to explain I haven't used Access or Excel in quite a few years and even then...I wasn't great

Attempt number 1:
IFF DateDiff("d",[Date],Now()) =>30 ,"Yes,"No"

There was a number 2..but I got annoyed and forgot to save changes

I'm not even sure if DateDiff is the function I want!

I know it should be an easy formula, but maybe sharepoint works differently I'm not sure

Thanks anyway



Edit:
Well it's IF and DIFFDATE as the functions.
Here's my latest attempt: IF DateDif([Date],Now(),"d") =>30 ,"Yes,"No"
Edited by Marma Duke - 6/15/11 at 6:10am
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 G0 3Ghz Asus P5K P35 HIS 4850 512MB 710/1110 4GB PC2-6400 (2x2GB) 
Hard DriveOSMonitorPower
Hitachi T7K500 320GB + 750GB NAS Windows 7 x64 2x 19" Hanns G 5ms (2880x900) EZCool 650Watt Modular 
Case
Aspire X-Plorer 
  hide details  
Reply
My System
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q6600 G0 3Ghz Asus P5K P35 HIS 4850 512MB 710/1110 4GB PC2-6400 (2x2GB) 
Hard DriveOSMonitorPower
Hitachi T7K500 320GB + 750GB NAS Windows 7 x64 2x 19" Hanns G 5ms (2880x900) EZCool 650Watt Modular 
Case
Aspire X-Plorer 
  hide details  
Reply