11-21-2012, 11:24 AM | #1 |
Evangelist
Posts: 405
Karma: 692
Join Date: Sep 2006
Device: Samsung Galaxy Note 3 | Kindle Paperwhite | iPad Mini
|
Help wanted on created a plugboard formula for date
I use calibre to update data to my releases.dearauthor.com site and as I was entering books today, I realized that some of my fields could easily be populated by a column from other columns, but I lack the knowledge on how to figure this out.
I'd be happy to pay someone to do this for me but essentially what I want to do is create a plugboard formula that takes the date published and populates another field called pub month. Therefore, if a book is published on August 13, 2013, the pub month field becomes 2013-Aug or something akin to that. Can anyone help a girl out? |
11-21-2012, 11:46 AM | #2 | |
Well trained by Cats
Posts: 29,784
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Preferences: Tweaks: find the "# Control how dates are displayed" tweak in the List set this one as shown gui_pubdate_display_format = 'yyyy-MMM' |
|
Advert | |
|
11-21-2012, 12:17 PM | #3 |
Evangelist
Posts: 405
Karma: 692
Join Date: Sep 2006
Device: Samsung Galaxy Note 3 | Kindle Paperwhite | iPad Mini
|
I still want to keep my regular date column so it looks like I need to build a column from a column and I used {pubdate:format_date(yy-MMM)}
Thanks for the lead. That was helpful. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Troubleshooting Kindle and math formula | DrShakalu | Amazon Kindle | 12 | 12-11-2011 07:25 AM |
Piracy, the new formula for success? | ImogenRose | General Discussions | 27 | 05-21-2011 08:56 PM |
Formula Plots | PuxyYunm | General Discussions | 9 | 05-15-2011 04:19 AM |
Plugboard for Pub Date needed | crossi | Library Management | 2 | 02-10-2011 12:46 PM |