0

When I import activities from a CSV using a date format that includes a 2-digit year (for example, mm/dd/yy), dates such as "01/18/22" get imported as January 18, 1922 instead of January 18, 2022.

It looks like years from 00 to 20 are assumed to be in the 21st century (2000-2020), but 21-99 are assumed to be in the 20th century (1921-1999).

How can I work around this?

Improve this question
2
  • have you modified any of the date settings at /civicrm/admin/setting/preferences/date?reset=1
    – petednz - fuzion ♦
    Commented Jan 19, 2022 at 3:14
  • 1
    The date preferences have no effect on this currently (CiviCRM 5.46). See a proposal to fix it: lab.civicrm.org/dev/core/-/issues/3037
    – Noah Miller
    Commented Jan 19, 2022 at 21:20

1 Answer 1

Reset to default
1

For the moment, the best workaround is to edit the activity dates in the CSV to have four-digit years before importing.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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