Home› NAV/Navision Classic Client

How to empty a datetime field?

gison
gison Posts: 128
2007-12-04 edited 2007-12-04 in NAV/Navision Classic Client
Dear all,

when i want to empty a datetime field by
DateTimeFieldName := '';
it give me error..but if i don't want to assign any time in, how can i clean this column
:?

kindly appreciate your idea.
0

Comments

  • DenSter
    DenSter Posts: 8,307
    2007-12-04
    Almost :mrgreen:
    DateTimeFieldName := 0DT;
    
    Daniel Rimmelzwaan
    RIS Plus, LLC
    0
  • Alex_Chow
    Alex_Chow Posts: 5,063
    2007-12-04
    Or
    CLEAR(DateTimeFieldName);
    
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
    0

Categories

  • All Categories
  • 75 General
  • 75 Announcements
  • 66.7K Microsoft Dynamics NAV
  • 18.8K 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
  • 611 NAV Courses, Exams & Certification
  • 2K Microsoft Dynamics-Other
  • 1.5K Dynamics AX
  • 253 Dynamics CRM
  • 103 Dynamics GP
  • 6 Dynamics SL
  • 1.5K Other
  • 991 SQL General
  • 383 SQL Performance
  • 34 SQL Tips & Tricks
  • 28 Design Patterns (General & Best Practices)
  • Architectural Patterns
  • 9 Design Patterns
  • 4 Implementation Patterns
  • 53 3rd Party Products, Services & Events
  • 1.6K General
  • 1K General Chat
  • 1.6K Website
  • 77 Testing
  • 1.2K Download section
  • 23 How Tos section
  • 249 Feedback
  • 12 NAV TechDays 2013 Sessions
  • 13 NAV TechDays 2012 Sessions