Visokio website     Downloads     Video tutorials     KnowledgeBase  
Data Manager: Dates coming out wrong in a csv - Visokio Forums
Data Manager: Dates coming out wrong in a csv
  • JohnMR June 16, 2017 9:58AM
    Hi all,
    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.
  • 3 Comments
  •     chris June 16, 2017 10:56AM
    Hi John,

    Thanks for the question. Can you post a sample of the CSV file?

    Thanks

    Chris
  •     chris June 16, 2017 10:56AM
    Also can you let us know what version of Omniscope you are using.
  •        daniel June 18, 2017 2:58AM
    That may actually be a setting in Excel auto-converting your csv file if you are opening it in there, check the same file in notepad as well.

Welcome!

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

Sign In Apply for Membership