Visokio website     Downloads     Video tutorials     KnowledgeBase  
Export: Date/time formats to Excel on a new PC? - Visokio Forums
Export: Date/time formats to Excel on a new PC?
  •     Panos June 17, 2014 12:55PM
    Hi

    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
  • 5 Comments
  •     paola June 18, 2014 1:14PM
    Hi Panos, couldn't reproduce the problem. Could you please post or email us directly a sample file/few rows of data.
  •     Panos June 19, 2014 4:41AM
    Sure,
    In the "Omniscope Date" image, you can see a sample of the date format and the dates.
    In the "Excel Date" image, you can see the output I get for the same dates.
  •        daniel June 19, 2014 5:00AM
    Could just be the language/regional settings in your Excel, it usually adopts whatever the PC's region is set to but you can change it in Excel. Check the default location on format cell and you can change it there.

    image
    Attachments
    Capture.PNG 28K
  •     Panos June 19, 2014 11:34AM
    Hi Daniel

    Thank you for your point, I know what you mean, unfortunately it doesn't work only by changing the format, because is in text format and some dates contain " 00:00:00" as well so I need to and create formulas to transform the text into date and get rid of " 00:00:00".
    My question is, why the output has the incorrect date format despite the fact the date format in Omniscope is correct? I would like to say also that, I receive the Omniscope output the same way I did it before, the only thing I have changed is my pc, so I needed to re-install the software.


    Kind Regards
    Panos
  •     paola June 19, 2014 11:53AM
    Please check your PC's system settings - region/language/dates etc. to make sure it is not set to US region in Windows. This will affect the Excel's date field formatting.
    image
    Attachments
    RegionSettings.JPG 72K

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership