Custom Date Field - Year is incorrect

Custom Date Field - Year is incorrect

by James Long -
Number of replies: 1

Help!

We're using a "date of hire" custom field and I have turned these boards upside down trying to find a solution to my problem:

The closest workable date format I've been able to find and use in the User Upload CSV is: YYYY-MM-DD, but after I've performed the CSV user upload, the Day/Month are correct and the Year is NOT correct!

Here are other formats I've tried:

  • YYYY-MM-DD-HH-MM-SS
  • "YYYY-MM-DD"
  • "YYYY-MM-DD-HH-MM-SS"

Here is the result of using 2006-05-12 in the DOHire custom field:


We have an uber-critical reporting need that will rely on this field, unfortunately. If this isn't going to work properly for us for whatever reason, would there be a way to use a custom field with date information and somehow trick Moodle into just thinking it's just plain ol' text (so that Moodle doesn't realize it needs to "help" me reformat the data)?

Average of ratings: -
In reply to James Long

Re: Custom Date Field - Year is incorrect

by James Long -
I found the solution with a little help from my colleague:

In Site administration / Users / Accounts / User profile fields
The custom date field was configured for start year and end year as 2020. We changed them to 1999 and 2038 ( if you try to make end year >2038, Moodle will give you an error when you go to upload your CSV).


Average of ratings: Useful (2)