MobileRead Forums - View Single Post - Dates

BetterRed · 10-09-2014, 09:56 PM

@theducks - Cut & paste won't to a conversion - there is no ISO Date format in Excel 2007, nor I suspect was there such a thing in Quattro, or the grandfather of all such things - Visicalc.

It is crazy that it's easier to pivot a table, or do an FFT in Excel than it is to deal with ISO dates - but that's the way it is I'm afraid.

If I use a general format eg 'yyyy-mm-dd' against the string 2014-12-31T23:15:49+00:00 it wont be reformatted, if I substr the 1st 10 chars I get 2014-12-31 as a date (value rather than a string) - but the value I entered into calibre was 2015-01-01!

I still don't understand why pubdate and #mydate are held inconsistently when I enter the same value.

I tried defining all the dates as 'iso' to see if it would the overcome the inconsistency . But when I do that I can't even enter a full date; month and year is all I can get, see attachment. And the peculiar value in My Published, that was what I got when I clicked Set "My Published' to today - I'm guessing this is a cutie five glitch.

I'll retain the template derived columns, they do work and I can use Excel's formatting features to get dates on which I can do arithmetic.

BR

10-09-2014, 09:56 PM	#7
BetterRed null operator (he/him) Posts: 21,802 Karma: 30237628 Join Date: Mar 2012 Location: Sydney Australia Device: none	@theducks - Cut & paste won't to a conversion - there is no ISO Date format in Excel 2007, nor I suspect was there such a thing in Quattro, or the grandfather of all such things - Visicalc. It is crazy that it's easier to pivot a table, or do an FFT in Excel than it is to deal with ISO dates - but that's the way it is I'm afraid. If I use a general format eg 'yyyy-mm-dd' against the string 2014-12-31T23:15:49+00:00 it wont be reformatted, if I substr the 1st 10 chars I get 2014-12-31 as a date (value rather than a string) - but the value I entered into calibre was 2015-01-01! I still don't understand why pubdate and #mydate are held inconsistently when I enter the same value. I tried defining all the dates as 'iso' to see if it would the overcome the inconsistency . But when I do that I can't even enter a full date; month and year is all I can get, see attachment. And the peculiar value in My Published, that was what I got when I clicked Set "My Published' to today - I'm guessing this is a cutie five glitch. I'll retain the template derived columns, they do work and I can use Excel's formatting features to get dates on which I can do arithmetic. BR Attached Thumbnails Last edited by BetterRed; 10-09-2014 at 10:02 PM.