I have built a feature report based on Survey123 data and need to change a date to text based on the year of the date. If the date has a year of 9999, I want to replace the full date with text. Is this something that is possible?
Hi @StevenHughes44,You could do this by using a conditional report element and the format method to return the year.For example:
${if (date1 |format:”YYYY”)==”9999”}
A year of 9999 was entered.
${/}
Thanks,-Barbara
Thank you for your help on this. When I use the element as written, I get an error stating the the end tag is unopened. If I load the template without the end tag, the report does generate with the element result of this:
@StevenHughes44 Can you provide the report template and XLSForm you're using?
I have attached the Word template for this feature report.
@StevenHughes44 Thanks for sending the template. It looks like you're missing a space after the "if".
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.