search

okfn / timemapper

Create and share elegant timelines and timemaps fast
http://timemapper.okfnlabs.org/
MIT License
273 stars 60 forks source link

TimeMapper Showing Incorrect Dates #210

Open historyjacobs opened 5 years ago

historyjacobs commented 5 years ago

This spreadsheet is producing a timemap with dates in 2019 and 2020, in the wrong months and on the wrong days. I can't figure out what's going on. Also, does anyone look at these issue posts? https://docs.google.com/spreadsheets/d/1Mfyz1fqRWMwcmRsQRYszyOXHZxbvugVNskYB1d9XIXk/edit?usp=sharing

ebeshero commented 5 years ago

@historyjacobs My students and I noticed this problem this month--if we chose the mm/dd/yyyy format the dates were pitched ahead by a month, I think. We switched to dd/mm/yyyy format and that resolved the problem for us. But TimeMapper devs should be reading these issues and responding and fixing this instead of leaving us to these workarounds...!

historyjacobs commented 5 years ago

@ebeshero Thank you! I tried fiddling with the date, to no avail... Hopefully a developer will weigh in on both issues!

ebeshero commented 5 years ago

@historyjacobs While I am not a developer here, I do a bit of development of my own. I just looked at your Google Sheet and I am sure you having the same problem one of my students was having yesterday: Your dates are formatted like this: 9/10/2017 But TimeMapper requires two digits each for the month and the day. If you are going with mm/dd/yyyy (which I do not recommend), you should be entering 09/10/2017. However(!) you may well object that Google Sheets doesn't let you enter this b/c it reformats to lose the leading zero. Not to worry. Highlight all your date cells, and convert them to Text. Do NOT let Google Sheets think of them as dates (though that may seem counterintuitive). Add your leading zeroes and they will hold as long as Sheets understands those cells to be "text." Please try it and let me know if it works.

I do hope an OFKN developer responds soon--I think the real bug they need to deal with is that the mm/dd/yyyy format is coming out a month off. I strongly recommend you use dd/mm/yyyy, but remember to reset your TimeMapper template to that format.

historyjacobs commented 5 years ago

That fix worked! Thank you so much!