Sage 100

 View Only

  • 1.  Bad Date?

    Posted 06-16-2020 17:31
    Trying to locate a possible bad date field in the AR History Header/Detail tables.  Access SQRY is blowing up.  I used to be able to pull raw data via VI Export to a CSV file and search for space in the date field.  But in v2019, when exporting date fields, the raw data (20200616) is converted to a formatted date 06/16/2020.  Is there a way to export without formatting?  VI, Excel, Crystal and Access are accessible tools for me.

    TIA

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------


  • 2.  RE: Bad Date?

    Posted 06-16-2020 17:40
    Sage made a utility... download from KB 89700

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Bad Date?

    Posted 06-16-2020 18:49
    Dang it!  I hate it when I forget about utilities that Sage has released and revert back to the "DOS" days......... I have even used it!  Thanks @Kevin Moyes for the reminder.
    ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------

    Original Message


Related Content