0

I'm creating a custom campaign naming convention and I need one part of the IF statements to return a fiscal year text value equal to "FY17","FY18", etc.

So, the logic is: If the date is between 7/1/16 and 6/30/17 then the text value returned is "FY17", etc.

This code needs to be built into an IF statement that is already differentiating between Opportunity Account Names.

Please let me know if any other information needs to be provided.

2
  • Is your org already using the platform's Fiscal Year functionality for forecasting, reporting, etc.?
    – Mark Pond
    Commented Mar 4, 2017 at 1:01
  • Can you be more specific about "This code needs to be built into an IF statement that is already differentiating between Opportunity Account Names."? Commented Mar 4, 2017 at 21:45

1 Answer 1

2

Try the following:

'FY' & RIGHT(TEXT( YEAR( My_Date__c ) + IF( MONTH( My_Date__c ) > 6, 1, 0)), 2)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .