• Converting from time format in excel

    By Rachman Maulana 4 years ago

    Hi,

    When i test to migrate with time format in excel, in notes database become number.
    How to solve it ?

    Tx

    • By David Jeyachandran 4 years ago

      Hi Rachman,

      I haven't worked with Notes (or the Data Moving Animal) for a long time so I'm not able to test this. Are you importing from Excel to Lotus Notes? One simple thing to try is under the advanced options add a formula for the date field. So @Date( DateColumn ).

      Let me know how that works.

      Thanks
      David