ToDate Function

  • Updated

The ToDate function converts an expression to a Date value.

Syntax 1

 

The ToDate function converts an expression to a Date value.

 

ToDate(year)

 

 

Arguments:

 

 

 

year

Integer - An integer or integer expression representing the year.

Syntax 2

 

The ToDate function converts an expression to a Date value.

 

ToDate(expression)

 

 

Arguments:

 

 

 

expression

Expression - The expression to convert, either by evaluating to a number or a date in string format.

Syntax 3

 

The ToDate function converts an expression to a Date value.

 

ToDate(year, month)

 

 

Arguments:

 

 

 

year

Integer - An integer or integer expression representing the year.

 

 

month

Integer - An integer or integer expression representing the month, in the range 1-12.

Syntax 4

 

The ToDate function converts an expression to a Date value.

 

ToDate(expression, month)

 

 

Arguments:

 

 

 

expression

Expression - The expression to convert, either by evaluating to a number or a date in string format.

 

 

month

Integer - An integer or integer expression representing the month, in the range 1-12.

Syntax 5

 

The ToDate function converts an expression to a Date value.

 

ToDate(year, month, day)

 

 

Arguments:

 

 

 

year

Integer - An integer or integer expression representing the year.

 

 

month

Integer - An integer or integer expression representing the month, in the range 1-12.

 

 

day

Integer - An integer or integer expression representing the day, in the range 1-31.

Syntax 6

 

The ToDate function converts an expression to a Date value.

 

ToDate(expression, month, day)

 

 

Arguments:

 

 

 

expression

Expression - The expression to convert, either by evaluating to a number or a date in string format.

 

 

month

Integer - An integer or integer expression representing the month, in the range 1-12.

 

 

day

Integer - An integer or integer expression representing the day, in the range 1-31.

Remarks

  • Example: ToDate("2005/1/1") returns 1/1/2005.
  • Example: ToDate(2005, 1, 28) returns 1/28/2005.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.