Postby Indiana » Mon Oct 04, 2010 7:45 pm
Kathryn wrote:
Indiana: I think the card.
Dh came home and we walked around our neighbourhood. We left some money for the accordion player since we've loved hearing him every evening. He is actually very good and introduces lots of flourish into his music. We'd come out of the subway and dh and I would simultaneously say, "He's there" as soon as we'd hear the music.
Didn't find anything to buy. No tiles. There were some cool things in Pier Import, including a sink side liquid soap, pot scrubber holder and some lovely china from a Barcelona company but nothing else. I'll either buy an ornament at the airport or leave without anything. I hate to do that, but I won't buy junk either and it isn't worth a trip to the tourist area. That's one of the problems with staying in a residential area; no souvenirs.
I grabbed my dinner from Burger King and dh joined me with a sundae. He'll have Chinese when the place opens (an hour or more from now.)
I got the Madrid expenses entered but discovered a flaw in Open Office. If a date is ambiguous, it stored as month/day/year despite it being entered as year/month/day. So if I entered 07/08/05 (August 5/07) it stored it as August 7, 2005, while displaying in the cell 05/08/07. But if I entered 2007/08/05, it stored 05/08/2007 and displayed 07/08/05, because it was clear the first number was the year. When I only entered 07, it thought the first number was the day. Dh had marked the data entry for that field as yy/mm/dd, so I was only entering 2 digits for the year.
Anyway, it was rough trying to figure out what was happening because I was assuming it was merely changing the display from yy/mm/dd to dd/mm/yy, not realizing it was completely corrupting all the dates I've entered. Dh didn't ever come across the problem because he always entered 2007. He took offense at me saying that if the software required yyyy/mm/dd, he should have documented that for me. He felt I shouldn't have expected him to know that Open Office would make assumptions.
The upshot is that every date I've entered into the spreadsheets over the past year are stored wrong. But they look okay and we don't do sorts on the dates, nor do we use the info automatically so the fact that it is wrong isn't going to spread to other programs. So I'm just going to leave it and do it correctly from this point onwards.