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:
Here is an example of the confirmations.csv with only 1 row of data.
When I enter the above confirmation number, this is how it populates the date.