Skip to main content
Topics#Data ManagementDavina Hanchuck 的问题
Davina Hanchuck (SGI, Tampa User Group Co-Leader) 提问于 #Data Management
2011年7月20日 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 个回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2011年7月20日 18:26
    Another option would be something like this:  

     

    IF(YEAR( Join_Date__c ) >= 2011,1,0)
撰写回答...
0/9000