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.
Comments
0 comments
Article is closed for comments.