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