Skip to main content
Topics#Data ManagementBruce MacLennan の質問
Bruce MacLennan (Glenduir) が「#Data Management」で質問
2014年2月3日 12:54

Referencing the start date of a custom fiscal period in a formula

How do I add a validation rule to an Opportunity Close Date to ensure it is in the current fiscal period?

 

I found this formula:

 

AND(

 

  OR (

 

     ISNEW(),

 

     ISCHANGED( CloseDate )),

 

  CloseDate < DATE( YEAR(TODAY()), MONTH(TODAY()), 1) )

 

this doesn't work when the start date of a fiscal period is say 30 March.
4 件の回答
回答を記入...
0/9000