Pacific Database

Home | Contact | FAQs | View Cart

A world of information at your fingertips

Date & Time :: Year functions

On this page you will find several functions for calculating year-related dates.

Two-digit year

    myInt = Year(dte)
    myString = Format(dte, "yy")

Four-digit year

    myString = Format(dte, "yyyy")
    myString = DatePart("yyyy", dte)