Skip to main content
Topics#Data ManagementFrage von Davina Hanchuck
Davina Hanchuck (SGI, Tampa User Group Co-Leader) fragte in #Data Management
20. Juli 2011, 18:11

Formula Help - Assign a number value to a date

Trying to create a formula field that will assign a value of 1 to my members with a join date greater than 1/1/2011, so I can run a report for a total count.

 

This is the formula I have, but I keep getting an error:

 

IF( Join_Date__c  >=  "01/01/2011"), 1, 0)

 

Any help is appreciated!
4 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    20. Juli 2011, 18:26
    Another option would be something like this:  

     

    IF(YEAR( Join_Date__c ) >= 2011,1,0)
Antwort schreiben...
0/9000