Edit

Day, Month, Year, Hour, Minute, Second, and Weekday functions

  • Article

Applies to: Canvas apps Dataverse formula columns Desktop flows Model-driven apps Power Platform CLI

Returns individual components of a Date/Time value.

Description

The Day function returns the day component of a Date/Time value, ranging from 1 to 31.

The Month function returns the month component of a Date/Time value, ranging from 1 to 12.

The Year function returns the year component of a Date/Time value, starting with 1900.

The Hour function returns the hour component of a Date/Time value, ranging from 0 (12:00 AM) to 23 (11:00 PM).

The Minute function returns the minute component of a Date/Time value, ranging from 0 to 59.

The Second function returns the second component of a Date/Time value, ranging from 0 to 59.

The Weekday function returns the weekday of a Date/Time value. By default, the result ranges from 1 (Sunday) to 7 (Saturday). You can specify a different range with an Microsoft Excel Weekday function code or a StartOfWeek enumeration value:

Excel code StartOfWeek enumeration Description
1, 17 StartOfWeek.Sunday Numbers 1 (Sunday) through 7 (Saturday). Default.
2, 11 StartOfWeek.Monday Numbers 1 (Monday) through 7 (Sunday).
3 StartOfWeek.MondayZero Numbers 0 (Monday) through 6 (Sunday).
12 StartOfWeek.Tuesday Numbers 1 (Tuesday) through 7 (Monday).
13 StartOfWeek.Wednesday Numbers 1 (Wednesday) through 7 (Tuesday).
14 StartOfWeek.Thursday Numbers 1 (Thursday) through 7 (Wednesday).
15 StartOfWeek.Friday Numbers 1 (Friday) through 7 (Thursday).
16 StartOfWeek.Saturday Numbers 1 (Saturday) through 7 (Friday).

All functions return a number.

See working with dates and times for more information.

Syntax

Day( DateTime )
Month( DateTime )
Year( DateTime )
Hour( DateTime )
Minute( DateTime )
Second( DateTime )

  • DateTime - Required. Date/Time value to operate on.

Weekday( DateTime [, WeekdayFirst ] )

  • DateTime - Required. Date/Time value to operate on.
  • WeekdayFirst - Optional. Excel code specifying which day starts the week. If not supplied, 1 (Sunday first) is used.

Examples

For the following example, the current time is 3:59:37 PM on Thursday, April 9, 2015.

Formula Description Result
Year( Now() ) Returns the year component of the current time and date. 2015
Month( Now() ) Returns the month component of the current time and date. 4
Day( Now() ) Returns the day component of the current time and date. 9
Hour( Now() ) Returns the hour component of the current time and date. 15
Minute( Now() ) Returns the minute component of the current time and date. 59
Second( Now() ) Returns the second component of the current time and date. 37
Weekday( Now() ) Returns the weekday component of the current time and date, using the default start of the week as Sunday. 5
Weekday( Now(), 14 ) Returns the weekday component of the current time and date, using an Excel code to specify the start of the week as Thursday. 1
Weekday( Now(), StartOfWeek.Wednesday ) Returns the weekday component of the current time and date, using a StartOfWeek enumeration to specify the start of the week as Wednesday. 2