You are here: Features > Cell Functions > Date and Time Functions > Date and Time Functions

Date and Time Functions

Use date and time functions to analyze and work with date and time values in formulas.

Function	Description
ADDMONTH	Takes a date and adds the specified number of months to it, returning the new date.
ADDYEAR	Takes a date and adds the specified number of years to it, returning a new date.
DAY	Returns the day as a numerical value.
DAYSTR	Returns the string value of the day of the week into an alphanumeric cell.
DMY	Returns the Julian serial number for the date entered.
DTOS	Converts a date to string format.
FMTDATESTR	Returns a formatted date string in a specified language
ITOD	Converts an integer format to date format.
LDATE	Returns a long date string based on the Regional Settings specified for the computer.
MKDATE	Converts any format to a date format.
MONTH	Returns the month as a numerical value.
MONTHSTR	Returns the string value of the month into an alphanumeric cell.
PERSTR	Returns a string representing the document's active period.
PERTOJ	Returns a Julian value for a specified reporting period's beginning or end date.
SDATE	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
SYSDATE	Returns the current system date.
SYSTIME	Returns the current system time.
VERDATE	Returns the date the active CaseView document was last saved.
VERSION	Returns the version of the active CaseView document.
VERTIME	Returns the time the active CaseView document was last saved.
YEAR	Returns the year as a numerical value.

Cookie Notice