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