Getting Started

 View Only
  • 1.  export to excel dates in different forms

    Posted 01-30-2020 08:58
    Hello,
    Does anyone know how I can solve this issue:
    When I extract my data to csv/excel the dates of my events are in different formats, 1/10/2020, meaning Jan 10 2020, or 1-10-2020, meaning october 10 2020. How can i make this unique? It looks all the same in QB.
    Thank you,
    Denise

    ------------------------------
    Denise Egas
    ------------------------------


  • 2.  RE: export to excel dates in different forms

    Posted 02-03-2020 19:23
    May i suggest to check the output files (CSV) first in a plain text editor like notepad to see if the output file is correct.
    further check the date settings on the app properties in QB so that QB indeed exports in the format as you expect

    Excel (or perhaps Microsoft) is also not very bright with CSV files both ways in my experience.
    I noticed that with some 'difficult files' you have a little it more control when you import the CSV via the wizard >Data>From text/CSV instead of opening the CSV file in excel and that convert to columns.


    ------------------------------
    Jan-Willem S
    ------------------------------