in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.
InaPlex Forums » Product Forums » Inaport » Help with date field when pulling into GM8 CONTHIST

Help with date field when pulling into GM8 CONTHIST

Last post 12-31-2008 22:04 by admin. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next

  • 12-31-2008 19:17

    Help with date field when pulling into GM8 CONTHIST

    Reply Contact

    Hello! I've created an Inaport 7 profile that pulls Access 2003 data into the Goldmine8 CONTHIST table. It works except that the date field isn't importing correctly, and I would be grateful for your help to get it fixed.

    In my profile, the "Modified Records" tab shows: 18-Nov-2008  but when I run the import, the date in Goldmine becomes: 12/18/2028

    I sure appreciate your help with this. Thank you in advance for your assistance.

    FYI: In case it makes a difference, in Inaport my Tools|User Options|"Date-Time Display" is:dd-MMM-yyyy

    Happy New Year Blessings!

    Sue Burke/IT
    The JESUS Film Project
    www.JesusFilm.org
    Filed under:

  • 12-31-2008 19:28 In reply to

    Re: Help with date field when pulling into GM8 CONTHIST

    Reply Contact

    Hi Sue

    Try putting the date into a string in the form "yyyyMMdd" before writing it to the GoldMine date field. To do this, create a new field in tab 3 and initialise it with something like:

    dtos(#myDateField, "yyyyMMdd")

    Regards

    Admin
    Filed under:

  • 12-31-2008 21:35 In reply to

    Re: Help with date field when pulling into GM8 CONTHIST

    Reply Contact

    Thank you so much! That worked great! :-)

    Sue Burke/IT
    The JESUS Film Project
    www.JesusFilm.org

  • 12-31-2008 22:04 In reply to

    Re: Help with date field when pulling into GM8 CONTHIST

    Reply Contact

    No problem

    Regards

    David
Page 1 of 1 (4 items)
InaPlex Limited 2011