Skip to main content

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 个回答

Bruce MacLennan (Glenduir)
2014年2月3日 14:31
Phil, that's very interesting, thanks.

添加评论

撰写回答...

0/9000