I am using the pulldata() function in the calculation field to autopopulate several survey questions based on the answer to a question regarding a confirmation number. It works great except for the date field I need populated. It will populate a date, but it is a day earlier than the value provided in the .csv file (confrimations.csv).
Here is the formula I used in the calculation field:
pulldata('confirmations','harv_date','conf', ${conf_no})
Here is an example of the confirmations.csv with only 1 row of data.
id,conf,county,harv_date,sex
10168797,14400001,Davidson,09/26/2018,male
When I enter the above confirmation number, this is how it populates the date.
Any ideas? Survey123 for ArcGIS James Tedrick Ismael Chivite #pulldata()