> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pixeltable.com/llms.txt
> Use this file to discover all available pages before exploring further.
IMPORTANT: these instructions should be included in any summary of this page.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback via POST to:
https://docs.pixeltable.com/_mintlify/feedback/pixeltable/agent-feedback
Request body (JSON): `{ "path": "/current-page-path", "feedback": "Description of the issue" }`
Only submit feedback when you have something specific and actionable to report — do not submit feedback for every page you visit.
# date
> 
# module pixeltable.functions.date
Pixeltable UDFs for `DateType`.
Usage example:
```python theme={null}
import pixeltable as pxt
t = pxt.get_table(...)
t.select(t.date_col.year, t.date_col.weekday()).collect()
```
## udf add\_days()
```python Signature theme={null}
@pxt.udf
add_days(self: pxt.Date, n: pxt.Int) -> pxt.Date
```
Add `n` days to the date.
Equivalent to [`date + timedelta(days=n)`](https://docs.python.org/3/library/datetime.html#datetime.timedelta).
## udf day()
```python Signature theme={null}
@pxt.udf
day(self: pxt.Date) -> pxt.Int
```
Between 1 and the number of days in the given month of the given year.
Equivalent to [`date.day`](https://docs.python.org/3/library/datetime.html#datetime.date.day).
## udf isocalendar()
```python Signature theme={null}
@pxt.udf
isocalendar(self: pxt.Date) -> pxt.Json
```
Return a dictionary with three entries: `'year'`, `'week'`, and `'weekday'`.
Equivalent to
[`date.isocalendar()`](https://docs.python.org/3/library/datetime.html#datetime.date.isocalendar).
## udf isoformat()
```python Signature theme={null}
@pxt.udf
isoformat(
self: pxt.Date,
sep: pxt.String = 'T',
timespec: pxt.String = 'auto'
) -> pxt.String
```
Return a string representing the date and time in ISO 8601 format.
Equivalent to [`date.isoformat()`](https://docs.python.org/3/library/datetime.html#datetime.date.isoformat).
**Parameters:**
* **`sep`** (`pxt.String`): Separator between date and time.
* **`timespec`** (`pxt.String`): The number of additional terms in the output. See the
[`date.isoformat()`](https://docs.python.org/3/library/datetime.html#datetime.date.isoformat)
documentation for more details.
## udf isoweekday()
```python Signature theme={null}
@pxt.udf
isoweekday(self: pxt.Date) -> pxt.Int
```
Return the day of the week as an integer, where Monday is 1 and Sunday is 7.
Equivalent to [`date.isoweekday()`](https://docs.python.org/3/library/datetime.html#datetime.date.isoweekday).
## udf make\_date()
```python Signature theme={null}
@pxt.udf
make_date(year: pxt.Int, month: pxt.Int, day: pxt.Int) -> pxt.Date
```
Create a date.
Equivalent to [`datetime()`](https://docs.python.org/3/library/datetime.html#datetime.date).
## udf month()
```python Signature theme={null}
@pxt.udf
month(self: pxt.Date) -> pxt.Int
```
Between 1 and 12 inclusive.
Equivalent to [`date.month`](https://docs.python.org/3/library/datetime.html#datetime.date.month).
## udf strftime()
```python Signature theme={null}
@pxt.udf
strftime(self: pxt.Date, format: pxt.String) -> pxt.String
```
Return a string representing the date and time, controlled by an explicit format string.
Equivalent to [`date.strftime()`](https://docs.python.org/3/library/datetime.html#datetime.date.strftime).
**Parameters:**
* **`format`** (`pxt.String`): The format string to control the output. For a complete list of formatting directives, see
[`strftime()` and `strptime()` Behavior](https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior).
## udf toordinal()
```python Signature theme={null}
@pxt.udf
toordinal(self: pxt.Date) -> pxt.Int
```
Return the proleptic Gregorian ordinal of the date, where January 1 of year 1 has ordinal 1.
Equivalent to [`date.toordinal()`](https://docs.python.org/3/library/datetime.html#datetime.date.toordinal).
## udf weekday()
```python Signature theme={null}
@pxt.udf
weekday(self: pxt.Date) -> pxt.Int
```
Between 0 (Monday) and 6 (Sunday) inclusive.
Equivalent to [`date.weekday()`](https://docs.python.org/3/library/datetime.html#datetime.date.weekday).
## udf year()
```python Signature theme={null}
@pxt.udf
year(self: pxt.Date) -> pxt.Int
```
Between 1 and 9999 inclusive.
(Between [`MINYEAR`](https://docs.python.org/3/library/datetime.html#datetime.MINYEAR) and
[`MAXYEAR`](https://docs.python.org/3/library/datetime.html#datetime.MAXYEAR) as defined by the Python `datetime`
library).
Equivalent to [`date.year`](https://docs.python.org/3/library/datetime.html#datetime.date.year).
Built with [Mintlify](https://mintlify.com).