# DATE

| Function        | Example call                                              | Expected result                                                    |
| --------------- | --------------------------------------------------------- | ------------------------------------------------------------------ |
| DATE            | DATE(2008, 7, 8)                                          | Tue Jul 08 2008 00:00:00 GMT-0700 (PDT)                            |
| DATEVALUE       | DATEVALUE('8/22/2011')                                    | Mon Aug 22 2011 00:00:00 GMT-0700 (PDT)                            |
| DAY             | DAY('15-Apr-11')                                          | 15                                                                 |
| DAYS            | DAYS('3/15/11', '2/1/11')                                 | 42                                                                 |
| DAYS360         | DAYS360('1-Jan-11', '31-Dec-11')                          | 360                                                                |
| EDATE           | EDATE('1/15/11', -1)                                      | Wed Dec 15 2010 00:00:00 GMT-0800 (PST)                            |
| EOMONTH         | EOMONTH('1/1/11', -3)                                     | Sun Oct 31 2010 00:00:00 GMT-0700 (PDT)                            |
| HOUR            | HOUR('7/18/2011 7:45:00 AM')                              | 7                                                                  |
| MINUTE          | MINUTE('2/1/2011 12:45:00 PM')                            | 45                                                                 |
| ISOWEEKNUM      | ISOWEEKNUM('3/9/2012')                                    | 10                                                                 |
| MONTH           | MONTH('15-Apr-11')                                        | 4                                                                  |
| NETWORKDAYS     | NETWORKDAYS('10/1/2012', '3/1/2013', \['11/22/2012'])     | 109                                                                |
| NETWORKDAYSINTL | NETWORKDAYSINTL('1/1/2006', '2/1/2006', 7, \['1/2/2006']) | 23                                                                 |
| NOW             | NOW()                                                     | Thu Feb 20 2020 23:02:55 GMT+0100 (Central European Standard Time) |
| NOW2            | NOW2()                                                    | 2024-02-22 10:55:23                                                |
| NOWTIME         | NOWTIME()                                                 | 14:22:23                                                           |
| SECOND          | SECOND('2/1/2011 4:48:18 PM')                             | 18                                                                 |
| TIME            | TIME(16, 48, 10)                                          | 0.700115741                                                        |
| TIMEVALUE       | TIMEVALUE('22-Aug-2011 6:35 AM')                          | 0.274305556                                                        |
| TODAY           | TODAY()                                                   | Thu Feb 20 2020 23:02:55 GMT+0100 (Central European Standard Time) |
| WEEKDAY         | WEEKDAY('2/14/2008', 3)                                   | 3                                                                  |
| YEAR            | YEAR('7/5/2008')                                          | 2008                                                               |
| WEEKNUM         | WEEKNUM('3/9/2012', 2)                                    | 11                                                                 |
| WORKDAY         | WORKDAY('10/1/2008', 151, \['11/26/2008', '12/4/2008'])   | Mon May 04 2009 00:00:00 GMT-0700 (PDT)                            |
| WORKDAYINTL     | WORKDAYINTL('1/1/2012', 30, 17)                           | Sun Feb 05 2012 00:00:00 GMT-0800 (PST)                            |
| YEARFRAC        | YEARFRAC('1/1/2012', '7/30/2012', 3)                      | 0.578082192                                                        |