topic Re: Calculate text value from Date field value in ArcGIS Survey123 Questions

Calculate text value from Date field value

JoeFlannery — Fri, 18 Nov 2016 18:27:26 GMT

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

Re: Calculate text value from Date field value

IsmaelChivite — Fri, 18 Nov 2016 21:19:52 GMT

type	name	label	calculation
date	aDate	Date
calculate	m	Month	format-date(${aDate},'%n')
calculate	day	Day	format-date(${aDate},'%e')
text	season	Season	if(${m}>10,'Winter',if(${m}>7,'Fall',if(${m}>5,'Summer',if(${m}>2,'Spring','Winter'))))

Re: Calculate text value from Date field value

JoeFlannery — Sat, 19 Nov 2016 22:39:00 GMT

Ismael:

Thank you for your insightful response worked for me! I'm sure others will find it useful.

We are all new to Survey123 and, I'm guessing, most of us are new to XLSform coding, too. My major takeaway from your response is that Excel formulas can be used in the XLSform that drives Survey123. I am learning a lot by building my first Surveys and I appreciate your Survey123 GeoNet blog posts, Survey123 online help and your personal responses to GeoNet questions. Hats off to you and your great team!

Joe

Re: Calculate text value from Date field value

NathanEnge — Tue, 17 Jan 2017 18:56:32 GMT

Ismael

I am trying to format my date field as:

format-date(${DATES},'%Y/%n/%e')

but what shows up on the survey is %Y/%n/%e

Any clues on how to best format the date as text to show yyyy/mm/dd or better yet yyyy_mm_dd?

Re: Calculate text value from Date field value

AbdulabnanMohammed — Tue, 15 Oct 2024 12:31:59 GMT

Hi @IsmaelChivite & Experts

I would like to include in between the date from and to and I have Applied a logic by going through your idea but it fails when i choose 27th feb 2026 then spring should be populated but it is considering winter
I have attached the XLS, Need Guidance how to correct or what i missed

I shall be thankful

Winter	Winter	From 11 Nov to 19 Feb.
Spring	Spring	From 20 Feb. to 20 May
Summer	Summer	From 21 May to 14 Aug
Autumn	Autumn	From 15 Aug. to 10 Nov