> For the complete documentation index, see [llms.txt](https://docs.qatts.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.qatts.com/functions/date-and-time.md).
# Date & Time
| Function | Description |
| ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATE | Returns a date, from a user-supplied year, month and day.
syntax: =DATE(year,month,dayOfMonth)
example: DATE(2017,1,21)
result: Returns Java Date Instance
|
| TIME | Returns a time, from a user-supplied hour, minute and second. |
| DATEVALUE | Converts a text string showing a date, to java date
syntax: =DATEVALUE(time\_in\_string, format(optional))
example: =DATEVALUE("12/12/2017") or
=DATEVALUE("12/12/2017","dd/mm/yyyy")
result: Java date instance
|
| | |
| TIMEVALUE | Converts a text string showing a time, to a decimal that represents the time in Excel.
example: =TIMEVALUE("10:10 AM")
result: java instance with time and default date
|
| NOW
| Returns the current date & time.
syntax: =NOW()
result: returns Java Date Instance with time
|
| TODAY | Returns today's date.
syntax: =TODAY()
result: returns Java Date Instance without time
|