aeontimeline

Open full view…

Date formatting in import files

manjug
Wed, 28 Sep 2016 15:33:27 GMT

There is something odd in how date formats are handled in import files. I use DD/MM/YYYY format, not MM/DD/YYYY, and have done for too many decades to allow me to change now. If I type a date which cannot be translated into the latter format (eg 27/4/2007 - 27th April) it imports correctly as DD/MM/YYYY. But if I type a date which can be translated by both formats (eg 10/5/2007) it imports as if it were MM/DD/YYYY (10th October, not 5th May). I can't find a setting which allows me to specify a default date setting for these purposes. Is there a way round this problem to avoid my having to change my date format habits of a considerable lifetime?

aeonjess
Wed, 28 Sep 2016 23:54:26 GMT

Hi, Thanks for letting us know about this issue. The preferred date order should be set to default to your computer's date settings, however in this case it seems not to be working. In order for us to debug the problem it would be helpful to know a few things: 1. Are you Mac or Windows? 2. What operating system you are using? 3. What are your exact computer's date settings? (including whether it uses dashes (-) or slashes(/) etc) Jess

manjug
Fri, 30 Sep 2016 07:25:11 GMT

I am using Windows 10. My computer's short date format is "dd-mmm-yy". Interestingly it doesn't offer date/month/year formatting with slashes, but other date formats have slashes (which I personally have always used). I have never noticed that before.

aeonjess
Fri, 30 Sep 2016 13:14:14 GMT

Hi, Thanks for that information, it was very helpful. We were able to find a bug when importing data when your computer's date format is set to "dd-mmm-yy". In order to fix this in the future we will probably add in an option for users to specify their date format and override the computer's settings, however in the meantime it should work for you if you change your format back to something that doesn't include the month name. but instead uses numbers. Eg. dd/MM/yy or d/MM/yy, dd/MM/yyyy etc. You said you didn't see any format that has date/month/year which I did find surprising, does that mean you don't have any formats like the ones I have listed above? The Windows 10 machine we have tested on does have these listed. If you do change your date format settings, please restart Aeon Timeline before you check if the import works with the correct format. Let us know if you still are having problems. Jess

manjug
Fri, 07 Oct 2016 17:41:05 GMT

Thank you for this helpful reply, and I look forward to a fix. But it has thrown up something very interesting (and disconcerting). In my version of Windows 10 the only short date option that I have in the drop-down menu for the date setting which puts the day first is dd-MMM-YY. I don't have an option for dd/mm/yy, or any other variant that puts "d" first. I shall have to investigate why that is (unless you or your assiduous users have an explanation and a fix ...)

aeonjess
Mon, 10 Oct 2016 02:20:45 GMT

Hi, I'm not exactly sure why this is, but I did a quick bit of googling, and found this website: http://www.sysprobs.com/change-date-format-windows-7-ddmmyyyy It mentions your problem (how there are no other options for a day first date format) and how you are able to create your own formats (so you can have dd/mm/yy) I haven't tested it to see if it works, but it might be something you want to try. Let us know if it works for you. Jess

manjug
Tue, 11 Oct 2016 06:52:07 GMT

Thank you for that link. In fact I found a buried setting elsewhere in additional settings (I have to choose a very specific UK version of "English" from a large number of others!) which did the same job (and I downloaded the UK Language pack - I don't know whether that made a difference). I am now able to tell Windows my short date format is dd/mm/yy. Now the date thing operates properly - if I put in 5/11/12 it Aeon gives me 5th November, which I want (not 11th May). Many thanks for your help. I can now make fuller use of Timeline 2.

slrb
Tue, 11 Oct 2016 17:00:10 GMT

Follow-on question...for custom calendars, how does the input formatting work? For example, if the date is 22 Blah, 3582, and Blah is the 5th month in the calendar, will AT accept 22/Blah/3582 and 22/05/3582 as valid inputs, or are there special rules for custom calendar month names/abbreviations?

aeonjess
Thu, 13 Oct 2016 23:19:52 GMT

Hi, There are no special rules for custom calendars. Aeon Timeline will accept any format in custom calendars that it does on the default calendar, therefore the above examples you gave will all work. The date format is still taken from your computer settings, so in your case, your custom calendars will also read in dd/mm/yyyy format. Jess

slrb
Thu, 20 Oct 2016 15:45:41 GMT

thanx!