Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category Date and Time functions

Note

This table contain only functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37).

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version

Name

Details

DATE

Version Added: Pre 2003

Returns the date represented by year, month, and day formatted according to the short date style in the system's Regional Settings. The values for year, month, and day reflect the Gregorian calendar.

Syntax

DATE(year,month,day)

Read more about function DATE

DATETIME

Version Added: Pre 2003

Returns the date and time value represented by datetime or expression.

Syntax

DATETIME("datetime"|expression[,lcid])

Read more about function DATETIME

DATEVALUE

Version Added: Pre 2003

Returns the date value represented by datetime or expression.

Syntax

DATEVALUE("datetime"|expression[,lcid])

Read more about function DATEVALUE

DAY

Version Added: Pre 2003

Returns an integer, 1 to 31, representing the day in datetime or expression. The DAY function uses the Gregorian calendar.

Syntax

DAY("datetime"|expression[,lcid])

Read more about function DAY

DAYOFYEAR

Version Added: Pre 2003

Returns an integer, 1 to 366, that represents the sequential day of the year in datetime or expression. The DAYOFYEAR function uses the Gregorian calendar.

Syntax

DAYOFYEAR("datetime"|expression[,lcid])

Read more about function DAYOFYEAR

HOUR

Version Added: Pre 2003

Returns an integer, 0 to 23, representing the hour of the day of datetime or expression.

Syntax

HOUR("datetime"|expression[,lcid])

Read more about function HOUR

MINUTE

Version Added: Pre 2003

Returns an integer from 0 to 59 that represents the minutes component of datetime or expression.

Syntax

MINUTE("datetime"|expression[,lcid])

Read more about function MINUTE

MONTH

Version Added: Pre 2003

Returns an integer from 1 to 12 that represents a month.

Syntax

MONTH("datetime"|expression[,lcid])

Read more about function MONTH

NOW

Version Added: Pre 2003

Returns the current date and time value.

Syntax

NOW ( )

Read more about function NOW

SECOND

Version Added: Pre 2003

Returns an integer, 0 to 59, that represents the seconds component of datetime or expression.

Syntax

SECOND("datetime"|expression[,lcid])

Read more about function SECOND

YEAR

Version Added: Pre 2003

Returns an integer that represents the Gregorian year in datetime or expression, formatted according to the short date style set by the system's current Region and Language settings.

Syntax

YEAR("datetime"|expression[,lcid])

Read more about function YEAR

TIME

Version Added: Pre 2003

Returns the time represented by hour, minute, and second.

Syntax

TIME(hour,minute,second)

Read more about function TIME

TIMEVALUE

Version Added: Pre 2003

Returns the time value represented by datetime or expression, based on the system's Region and Language settings.

Syntax

TIMEVALUE("datetime"|expression[,lcid])

Read more about function TIMEVALUE

WEEKDAY

Version Added: Pre 2003

Returns an integer, 1 to 7, representing the weekday in datetime or expression.

Syntax

WEEKDAY("datetime"|expression[,lcid])

Read more about function WEEKDAY

YEAR

Version Added: Pre 2003

Returns an integer that represents the Gregorian year in datetime or expression, formatted according to the short date style set by the system's current Region and Language settings.

Syntax

YEAR("datetime"|expression[,lcid])

Read more about function YEAR