topic Relevancy based on today's date being between two dates in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/relevancy-based-on-today-s-date-being-between-two/m-p/817710#M15048 <HTML><HEAD></HEAD><BODY><P>Trying to create numerous questions where they only appear if today's date falls between two dates.</P><P></P><P>Currently have a hidden field with calculation of "format-date(yyyy//mm//dd)" and tried the following formula in the relevant column for my series questions "today() &lt; date('2021/06/31') and &gt; date('2016/06/31)".</P><P></P><P>Have not been successful, do I need to replace today() with a&nbsp;field I created myself and can I even do between &gt; and &lt; relevant formulas?<BR /><BR /></P><P>Much appreciated</P></BODY></HTML> Wed, 23 Oct 2019 01:38:29 GMT JamesBailey 2019-10-23T01:38:29Z Relevancy based on today's date being between two dates https://community.esri.com/t5/arcgis-survey123-questions/relevancy-based-on-today-s-date-being-between-two/m-p/817710#M15048 <HTML><HEAD></HEAD><BODY><P>Trying to create numerous questions where they only appear if today's date falls between two dates.</P><P></P><P>Currently have a hidden field with calculation of "format-date(yyyy//mm//dd)" and tried the following formula in the relevant column for my series questions "today() &lt; date('2021/06/31') and &gt; date('2016/06/31)".</P><P></P><P>Have not been successful, do I need to replace today() with a&nbsp;field I created myself and can I even do between &gt; and &lt; relevant formulas?<BR /><BR /></P><P>Much appreciated</P></BODY></HTML> Wed, 23 Oct 2019 01:38:29 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevancy-based-on-today-s-date-being-between-two/m-p/817710#M15048 JamesBailey 2019-10-23T01:38:29Z Re: Relevancy based on today's date being between two dates https://community.esri.com/t5/arcgis-survey123-questions/relevancy-based-on-today-s-date-being-between-two/m-p/817711#M15049 <HTML><HEAD></HEAD><BODY><P>In programming you always have to write out the statement in full.&nbsp; It has no idea what you want to compare in the other side of the and.</P><P></P><P>So&nbsp;</P><P><SPAN style="background-color: #ffffff;">today() &lt; date('2021/06/31') and today() &gt; date('2016/06/31)</SPAN></P></BODY></HTML> Wed, 23 Oct 2019 16:31:46 GMT https://community.esri.com/t5/arcgis-survey123-questions/relevancy-based-on-today-s-date-being-between-two/m-p/817711#M15049 DougBrowning 2019-10-23T16:31:46Z