Date and Time Functions
Use date and time functions to analyze and work with date and time values in formulas.
Function |
Description |
Takes a date and adds the specified number of months to it, returning the new date. |
|
Takes a date and adds the specified number of years to it, returning a new date. |
|
Returns the day as a numerical value. |
|
Returns the string value of the day of the week into an alphanumeric cell. |
|
Returns the Julian serial number for the date entered. |
|
Converts a date to string format. |
|
FMTDATESTR | Returns a formatted date string in a specified language |
Converts an integer format to date format. |
|
Returns a long date string based on the Regional Settings specified for the computer. |
|
Converts any format to a date format. |
|
Returns the month as a numerical value. |
|
Returns the string value of the month into an alphanumeric cell. |
|
Returns a string representing the document's active period. |
|
Returns a Julian value for a specified reporting period's beginning or end date. |
|
Returns a short date string based on the Regional Settings specified for the computer. |
|
SDATETOJ | Returns a Caseware date in numeric format from a date string in the current Windows format |
Returns the current system date. |
|
Returns the current system time. |
|
Returns the date the current CaseView document was last saved. |
|
Returns the version of the current CaseView document. |
|
Returns the time the current CaseView document was last saved. |
|
Returns the year as a numerical value. |