Skip to main content
Topics#Data ManagementMatt Brown's Question
Matt Brown (Appirio) asked in #Data Management
Feb 8, 2012, 5:56 PM

Need to use something similar to DATEVALUE formula to pull a Date not Date/Time

I am having a problem trying to get the below formula to work and I know it is because my field is a Date field and not a Date/Time field but I need correct the DATEVALUE to something to give me the same result. Here is my formula:

 

IF( 

 

(TODAY() - DATEVALUE(Risk_Assessment_Date__c) <= 90) 

 

, "Fresh", "Old")

 

Risk_Assessment_Date__c is a Date field. DATEVALUE only works with Date/Time fields.

 

Can anyone point me in the right direction to accomplish this please?
6 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Feb 8, 2012, 6:13 PM
    Why are you converting the 'Risk_Assessment_Date__c' field?  

     

    Shouldn't this work?

     

    IF((TODAY() - Risk_Assessment_Date__c) <= 90, "Fresh", "Old")

Write an answer...
0/9000