Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
NAV/Navision Classic Client
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
Categories
All Categories
73
General
73
Announcements
66.6K
Microsoft Dynamics NAV
18.7K
NAV Three Tier
38.4K
NAV/Navision Classic Client
3.6K
Navision Attain
2.4K
Navision Financials
116
Navision DOS
851
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
617
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
320
Dynamics CRM
111
Dynamics GP
10
Dynamics SL
1.5K
Other
990
SQL General
383
SQL Performance
34
SQL Tips & Tricks
35
Design Patterns (General & Best Practices)
1
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.6K
General
1K
General Chat
1.6K
Website
83
Testing
1.2K
Download section
23
How Tos section
252
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Options
Mute
Import Time Value from Excel
elkarmo
Member
Posts:
5
2006-02-17
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....
0
Comments
ara3n
Member
Posts:
9,258
2006-02-17
did you try evaluate(mytime,cell.value)?
Ahmed Rashed Amini
Independent Consultant/Developer
blog:
https://dynamicsuser.net/nav/b/ara3n
0
kriki
Member, Moderator
Posts:
9,120
2006-02-17
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!
0
Sign In
or
Register
to comment.
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
The second parameter of EVALUATE should be a text, so maybe it is necessary to FORMAT the variant-value.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!