Passing a date in the extra attributes of the plot CSV

Question

I am trying to add a date column to the CSV of the grid of my plots.

It seems that the date attribute that I am trying to "link it to" is not understanding the date format or something.

Currently my CSV looks a like this:

id,Ycoordinate,Xcoordinate,visit_date,plot_type
1,-31.28116389,148.9776111,2018-05-11,3
2,-31.27856667,148.9924667,2018-05-12,3
3,-30.45390278,149.2280417,2018-05-13,3

but when I use this CSV on my survey I keep getting an error about the date attribute not being filled...

alt text

Answer 1

In order to use dates as "From CSV" type of attributes Collect Earth expects this format:

MM/dd/YYYY ( so two digits month, two digits day and four digit year )

So, in your case, the format to use dates as grid columns in the CSV should be:

id,Ycoordinate,Xcoordinate,visit_date,plot_type
1,-31.28116389,148.9776111,11/05/2018,3
2,-31.27856667,148.9924667,15/05/2018,3
3,-30.45390278,149.2280417,25/06/2018,3

Passing a date in the extra attributes of the plot CSV

Follow this question

Related questions