Timeline Link Data to Shapes - ignores date from Excel

Started by michigandrea, August 12, 2014, 03:20:14 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

michigandrea

I am trying to create a timeline from linked data in an Excel spreadsheet.  The data is very simple - four columns with an ID, Task Name, Date, and Start time. I am following the instructions here http://www.k-state.edu/today/announcement.php?id=1460 but I can't get the date to come over from Excel - it inserts 12/30/1899 and I have to manually change it to the date I'd like.

I have a feeling this process is not as easy as it seems at first glance, but I am not sure what else to try, or where else to look for additional guidance.

Thanks!

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 132 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1050KB.
Tokens: post-login.
Cache hits: 13: 0.00181s for 26,602 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]