AnsweredAssumed Answered

Calculate text value from Date field value

Question asked by jrflannery on Nov 18, 2016
Latest reply on Jan 17, 2017 by nengeesri-ca-esridist

I would like to automatically populate a "Season" text field in my bird survey given a DateTime value in the survey.  The “Bird Seasons” that I am using are shown below.  In my survey, I already have a DateTime field.  Can I use a formula or calculation to grab the DateTime value and pick the right Bird Season that corresponds to the date?  Any guidance is much appreciated.

 

Bird Seasons

Winter = Nov. 1 thru Feb. 29

Spring = March 1 thru May 31

Summer = June 1 thru July 31

Fall = Aug. 1 thru Oct. 31

 

 

Thank you,

Joe

Outcomes