Import Time Value from Excel

elkarmo
elkarmo Member Posts: 5
edited 2006-02-17 in NAV/Navision Classic Client
Hi all, i'm serching for a solution for import the time value from an excel workbook...
I had try to use the VARIANT2TIME, but it want that the value is a Date,Time...
My field is only time value....
You can help me, please???
Thanks....

Comments

  • ara3n
    ara3n Member Posts: 9,258
    did you try evaluate(mytime,cell.value)?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,127
    Or EVALUATE(mytime,FORMAT(cell.value))
    The second parameter of EVALUATE should be a text, so maybe it is necessary to FORMAT the variant-value.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories