Time and Date Functions
      Back to home
      1. Datagration Knowledge Base
      2. P#
      3. Time and Date Functions

      Year()

      Returns the day/ the day of year/ minute/ hour/ month/ millisecond/ second/ year component of the specified date/time or current time step.

      Syntax

      Day(date)

      DayOfYear(date)

      Minute(date)

      Hour(date)

      Month(date)

      Millisecond(date)

      Second(date)

      Year(date)
        • date: optional, if this argument is not specified, current time step will be used

      Examples

      Year() returns the year of the current step

      Month(#05/16/2000#) returns 5

      Day(#05/16/2000#) returns 16

      DayOfYear(#05/16/2000#) returns 137

      DayOfYear(Now()) returns the day number of the current year