---
title: "Passing a date in the extra attributes of the plot CSV"
url: "https://openforis.support/questions/2788/passing-a-date-in-the-extra-attributes-of-the-plot-csv"
tags: ["collectearth"]
status: "answered"
score: 0
answer_count: 1
asked: "2020-04-14T23:49:12"
last_activity: "2020-04-16T11:21:20"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Passing a date in the extra attributes of the plot CSV

Asked by collector on 2020-04-14

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][1]


  [1]: http://www.openforis.org/support/upfiles/googleearth_2020-04-14_23-48-04.png


## Answer (score 0, by collectearth on 2020-04-16)

Link: https://openforis.support/questions/2788/passing-a-date-in-the-extra-attributes-of-the-plot-csv/2790

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