CiviCRM Community Forums (archive)

There is a bug on this,  CRM-14220.  It's marked as trivial. 

The bug was reported back in Feb.  It looks like it is targeted for 4.6.  I understand there may not be very many people using that format but it seems like on releases until it is fixed, it should at least give an error so one knows it doesn't work at all.  I believe it worked at one point.  I have a couple fields on profiles that are used by our constituents with just yyyy, and, of course, after I send out a bulk email getting people to update info via the profile I find out all the year data anyone entered never made it into the db.  Shame on me for not fully testing something that I think use to work and for not noticing during some testing but we've used the profile before.

I realize the work to fix this is probably volunteer and I am not bemoaning the fact that it hasn't been fixed yet, just that a known data issue doesn't even raise an error.

I also realize that there may be questions on just how it the date should be actually stored in the db and pulled back.  It looks like based on forum post back through many years, people have complained about using YYYY and then getting back day and month info as well.  My 2 cents is store it in the database as YYYY-01-01 00:00.  That way it looks like it was deliberate if you actually look at the db.