Answers.Body: <p>When I have had something like this I have just set the dates to 01/01/2018 or 01/01/2020 in the file to be imported, which means that if you set the date more precisely for future contacts entered in directly that you can still sort by the date. Just means that if its the first day of the year it might not be precise. As long as users are aware of this, then I can't see that causing any problems.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-23T16:49:59.660Z
Answers.Text: Thanks, that is what I ended up doing in the end.
Answers.UserDisplayName: Kurt Leadley
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-26T17:01:24.690Z
Answers.LastActivityDate: 2021-02-26T17:01:24.690Z
Answers.UserDisplayName: Mick Kahn
Body: <p>Is it possible to do a Contact import where a date column is in year only format (2018,2020 etc)? I tried looking at the Administer -&gt; Localization -&gt; Date Formats and noticed year only is an option for &quot;Date Display&quot;, but it doesn't appear as an option in Contacts -&gt; Import Contacts. I can't find anything about it in the official documentation.</p>
  <p>Furthermore, If it cannot be done, are there any negative effects functionality wise (Filtering data/ Reports) if I was to change the format to Alphanumeric? The customer really wants it to be date format.</p>
  <p>Edit: I'm guessing that even if it is in year only display, it needs to have an actual real date associated with it to be a valid &quot;Date&quot;. I'm just concerned for functionality reasons.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-02-25T18:15:14.710Z
Comments.Text: iirc the standard workaround has just been to import those as eg 01-01-yyyy
Comments.UserDisplayName: petednz - fuzion
Tags: <import><date-preferences>
Title: Year only import
ThreadText: # Year only import
  
  (Asked by: username_0 on 2021-02-25)
  
  Is it possible to do a Contact import where a date column is in year only format (2018,2020 etc)? I tried looking at the Administer -> Localization -> Date Formats and noticed year only is an option for "Date Display", but it doesn't appear as an option in Contacts -> Import Contacts. I can't find anything about it in the official documentation.
  
  Furthermore, If it cannot be done, are there any negative effects functionality wise (Filtering data/ Reports) if I was to change the format to Alphanumeric? The customer really wants it to be date format.
  
  Edit: I'm guessing that even if it is in year only display, it needs to have an actual real date associated with it to be a valid "Date". I'm just concerned for functionality reasons.
  
  **Tags:** import, date-preferences
  
  > **Comments:**
  > **username_1**: iirc the standard workaround has just been to import those as eg 01-01-yyyy  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2021-02-26. Score: 1 | Accepted answer
  
  When I have had something like this I have just set the dates to 01/01/2018 or 01/01/2020 in the file to be imported, which means that if you set the date more precisely for future contacts entered in directly that you can still sort by the date. Just means that if its the first day of the year it might not be precise. As long as users are aware of this, then I can't see that causing any problems.
  
  > **Comments:**
  > **username_0**: Thanks, that is what I ended up doing in the end.  
  
  ---
  
  