http://forums.visokio.com/discussions/tagged/importing-Excel_dates_times/feed.rss Mon, 30 Oct 17 12:25:02 -0400 Tagged with importing-Excel_dates_times - Visokio Forums en-CA http://forums.visokio.com/discussion/3251/data-manager-dates-coming-out-wrong-in-a-csv Fri, 16 Jun 2017 09:58:03 -0400 JohnMR 3251@/discussions I've created a file that has dates info. When I pull the dates in the UK format (dd/MM/yyyy) everything is fine but if I use the field organiser to change to US format (MM/dd/yyyy) the csv date column is half in dates (if you use show formula it's a number like 42045) but half is no dates (if you go to show formulas it's 02/10/2015). Why is this happening? It doesn't happen if I use UK dates.
Thanks,
John.]]> http://forums.visokio.com/discussion/2602/export-datetime-formats-to-excel-on-a-new-pcs Tue, 17 Jun 2014 12:55:28 -0400 Panos 2602@/discussions
I face some issues with the date format. While all the dates are formatted properly on my Omniscope final box (dd/mm/yyyy), when I publish the file in Excel format, some of the dates change on text format (mm/dd/yyyy hh:mm:ss) and the rest are still on date format (mm/dd/yyyy).

I started to face that issues since I changed my PC, I am telling that just in case there is an option I have to change.

Thanks, Panos]]> http://forums.visokio.com/discussion/1968/datetime-import-specific-date-formats Thu, 03 Jan 2013 09:24:38 -0500 briansj 1968@/discussions
28/12/12 23:59

I am using dd/MM/yy HH:mm to try to get this to read as a date in field organizer, but this format returns a blank

]]> http://forums.visokio.com/discussion/1931/datetime-excel-import-dates-parsed-as-numberss Fri, 30 Nov 2012 10:50:00 -0500 tommyc 1931@/discussions http://forums.visokio.com/discussion/1401/sources-excel-date-formattings Mon, 19 Mar 2012 11:29:28 -0400 schergr 1401@/discussions
If I change the date formatting in Excel, I get 3/14/11, but I do want the full four digit year. Am I doing something wrong?]]>