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.

  • 1
    iirc the standard workaround has just been to import those as eg 01-01-yyyy
    – petednz - fuzion
    Feb 25 at 18:15

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.

  • Thanks, that is what I ended up doing in the end. Mar 23 at 16:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.