Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Learn
Suggestions will filter as you type
Sign in

  • Profile
  • Settings
Sign out
Learn
    • Documentation

      In-depth articles on Microsoft developer tools and technologies

    • Training

      Personalized learning paths and courses

    • Credentials

      Globally recognized, industry-endorsed credentials

    • Q&A

      Technical questions and answers moderated by Microsoft

    • Code Samples

      Code sample library for Microsoft developer tools and technologies

    • Assessments

      Interactive, curated guidance and recommendations

    • Shows

      Thousands of hours of original programming from Microsoft experts

    Microsoft Learn for Organizations

    Boost your team's technical skills

    Access curated resources to upskill your team and close skills gaps.

    • ASP.NET
    • Azure
    • Dynamics 365
    • Microsoft 365
    • Microsoft Copilot
    • Microsoft Edge
    • Microsoft Entra
    • Microsoft Graph
    • Microsoft Intune
    • Microsoft Purview
    • Microsoft Teams
    • .NET
    • Power Apps
    • Power BI
    • Power Platform
    • PowerShell
    • SQL
    • Sysinternals
    • Visual Studio
    • Windows
    • Windows Server
    View all products

    Microsoft Learn for Organizations

    Boost your team's technical skills

    Access curated resources to upskill your team and close skills gaps.

    • C++
    • C#
    • DAX
    • Java
    • OData
    • OpenAPI
    • Power Query M
    • VBA

    Microsoft Learn for Organizations

    Boost your team's technical skills

    Access curated resources to upskill your team and close skills gaps.

    • Artificial intelligence
    • Compliance
    • DevOps
    • Platform engineering
    • Security

    Microsoft Learn for Organizations

    Boost your team's technical skills

    Access curated resources to upskill your team and close skills gaps.

Suggestions will filter as you type
Sign in

  • Profile
  • Settings
Sign out

This content has been retired and may not be updated in the future. The product, service, or technology mentioned in this content is no longer supported.

Return to main site
Suggestions will filter as you type
  • Welcome to the Developer and IT-Pro Help
  • Getting Started
  • Product and Architecture Overview
  • Deployment
  • Development in C/AL
    • Development in C/AL
    • Application Design Overview
    • Programming in C/AL
    • Objects
    • Web Services
    • Events in Microsoft Dynamics NAV
    • Notifications
    • Extending Microsoft Dynamics NAV
    • Developing for the Microsoft Dynamics NAV Web Client
    • Developing for the Microsoft Dynamics NAV Universal App
    • Customizing Dynamics 365 for Sales and Dynamics NAV Integration
    • Multilanguage Development
    • Instrumenting for Telemetry
    • Testing the Application
    • Debugging
    • Comparing and Merging Application Object Source Files
    • Technical Reference
      • Technical Reference
      • C/SIDE Reference Guide
      • C/AL Functions
        • C/AL Functions
        • Functions Not Supported by Microsoft Dynamics NAV Web Client
        • Automation Data Type
        • BigInteger Data Type
        • BigText Data Type
        • BLOB Data Type
        • Boolean Data Type
        • Byte Data Type
        • Char Data Type
        • Code Data Type
        • Codeunit Data Type
        • Database
        • Dates and Times
          • Dates and Times
          • Date Data Type
          • DateFormula Data Type
          • DateTime Data Type
          • Duration Data Type
          • Time Data Type
          • Date and Time Functions
            • Date and Time Functions
            • CALCDATE Function (Date)
            • CLOSINGDATE Function (Date)
            • DATE2DMY Function (Date)
            • DATE2DWY Function (Date)
            • DATI2VARIANT Function
            • DMY2DATE Function (Date)
            • DWY2DATE Function (Date)
            • NORMALDATE Function (Date)
            • TIME Function (Time)
            • TODAY Function (Date)
            • VARIANT2DATE Function
            • VARIANT2TIME Function
            • WORKDATE Function (Date)
          • DateTime Functions
        • Debugger
        • Decimal Data Type
        • Dialog Data Type
        • FieldRef Data Type
        • File Data Type
        • FilterPageBuilder Data Type
        • GUID Data Type
        • InStream and OutStream Data Types
        • Integer Data Type
        • KeyRef Data Type
        • Media Data Type
        • MediaSet Data Type
        • NAV App
        • Notification Data Type
        • Numbers
        • OCX Data Type
        • Option Data Type
        • Page Data Type
        • Query Data Type
        • Record Data Type
        • RecordID Data Type
        • RecordRef Data Type
        • Report Data Type
        • Sessions
        • Strings
        • System
        • TableConnectionType Data Type
        • TaskScheduler Data Type
        • TableFilter Data Type
        • Test Pages
        • TestPage Data Type
        • TestRequestPage Data Type
        • Text Data Type
        • TransactionType Data Type
        • Variant Data Type
        • XMLport Data Type
      • Properties
      • Development Environment Commands
  • Development in AL
  • Administration
  • Security and Protection
  • Upgrading to Microsoft Dynamics NAV 2018
  • Windows PowerShell Cmdlets
  • Business Central API Reference v1.0
  • Business Central API Reference v2.0
  1. Learn
  2. Previous Versions
  3. Development in C/AL
  4. Technical Reference
  5. C/AL Functions
  6. Dates and Times
  1. Learn
  2. Previous Versions
  3. Development in C/AL
  4. Technical Reference
  5. C/AL Functions
  6. Dates and Times
Read in English
Save
Read in English

Share via

Facebook x.com LinkedIn Email

Date and Time Functions

  • Article
  • 06/05/2016

In this article

This section contains the following topics:

  • CALCDATE Function (Date)

  • CLOSINGDATE Function (Date)

  • DATE2DMY Function (Date)

  • DATE2DWY Function (Date)

  • DATI2VARIANT Function

  • DMY2DATE Function (Date)

  • DWY2DATE Function (Date)

  • NORMALDATE Function (Date)

  • TIME Function (Time)

  • TODAY Function (Date)

  • VARIANT2DATE Function

  • VARIANT2TIME Function

  • WORKDATE Function (Date)


Additional resources

English (United States)
California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2024

Additional resources

In this article

English (United States)
California Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2024