CDpedia dates gone wild

Talk to other Pedia users about the programs, share tricks and tips or ask questions about existing features.

CDpedia dates gone wild

Postby rpali » Mon Jan 16, 2012 11:30 pm

Something's very wrong with date formatting. I've searched the forums and it seems that this is not a widespread problem. It seems limited to just me.

I added two CDs today. The Date Added field values for those two CDs report 2012-42-16 and 2012-16-16. How are those for dates?!

In CDpedia, my date formats are yyyy for release and yyyy-mm-d for other dates. In system prefs, I use yyyy-mm-dd for short and medium length dates. Does this mismatch matter? I noticed things going nutty at the beginning of December because I build a smart list each month listing the CDs added in the current month. I also usually keep three or four previous smart lists. November's list worked just fine when I created it at the beginning of that month and it still works fine.

Either I edited the date formats in the interim, or it was a new version of CDpedia. The funny thing is, if I create a smart list, and enter a date, I can go and edit it, and the date has changed.

Any ideas? This one's got me stumped. Whatever the cause, I certainly hope my database isn't messed up....which it certainly appears to be, at least as far as the month and day of the dates go!
rpali
Bruji Friend
Bruji Friend
 
Posts: 14
Joined: Sat May 03, 2008 11:01 am

Re: CDpedia dates gone wild

Postby Nora » Wed Jan 18, 2012 11:08 am

The problem in this case is the date format: yyyy-mm-d. "m" stands for minutes. "M" stands for month. So what you want to use is "yyyy-MM-d" to get the date format "2012-01-18". A short list of date formats is included in the CDpedia Help files or you can find a full version of the formats available on this site.
User avatar
Nora
Site Admin
 
Posts: 2155
Joined: Sun Jul 04, 2004 5:03 am

Re: CDpedia dates gone wild

Postby rpali » Wed Jan 18, 2012 8:07 pm

Worked like an absolute charm. Thank you very kindly for your help!
rpali
Bruji Friend
Bruji Friend
 
Posts: 14
Joined: Sat May 03, 2008 11:01 am


Return to PediaTalk

cron