function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mhellarmhellar 

Defining Specific month in Year.

Hi,

 

I have this formula which assign a students high school level. based on how many years thy have been in school.

 

CASE(YEAR(TODAY()) - High_School_Start_Date__c,1,"Freshman",2,"Sophmore",3,"Junior",4,"senior","NA")

 

I'd like to modify it so that it calculates it by September  of the current year instead of today. Does anyone have an idea on how to do that? Thanks in advance.

 

Best,

Mark

hhuiehhuie

Replace YEAR(TODAY()) with

 

DATE(YEAR(TODAY()),9,1)