Configure a date column in st.dataframe or st.data_editor.

This is the default column type for date values. This command needs to be used in the column_config parameter of st.dataframe or st.data_editor. When used with st.data_editor, editing will be enabled with a date picker widget.

Function signature[source]

st.column_config.DateColumn(label=None, *, width=None, help=None, disabled=None, required=None, pinned=None, default=None, format=None, min_value=None, max_value=None, step=None)

Parameters

label (str or None)

The label shown at the top of the column. If this is None (default), the column name is used.

width ("small", "medium", "large", or None)

The display width of the column. If this is None (default), the column will be sized to fit the cell contents. Otherwise, this can be one of the following:

  • "small": 75px wide
  • "medium": 200px wide
  • "large": 400px wide

help (str or None)

An optional tooltip that gets displayed when hovering over the column label. If this is None (default), no tooltip is displayed.

disabled (bool or None)

Whether editing should be disabled for this column. If this is None (default), Streamlit will decide: indices are disabled and data columns are not.

If a column has mixed types, it may become uneditable regardless of disabled.

required (bool or None)

Whether edited cells in the column need to have a value. If this is False (default), the user can submit empty values for this column. If this is True, an edited cell in this column can only be submitted if its value is not None, and a new row will only be submitted after the user fills in this column.

pinned (bool or None)

Whether the column is pinned. A pinned column will stay visible on the left side no matter where the user scrolls. If this is None (default), Streamlit will decide: index columns are pinned, and data columns are not pinned.

default (datetime.date or None)

Specifies the default value in this column when a new row is added by the user. This defaults to None.

format (str or None)

A momentJS format string controlling how times are displayed. See momentJS docs for available formats. If this is None (default), the format is YYYY-MM-DD.

Number formatting from column_config always takes precedence over number formatting from pandas.Styler.

min_value (datetime.date or None)

The minimum date that can be entered. If this is None (default), there will be no minimum.

max_value (datetime.date or None)

The maximum date that can be entered. If this is None (default), there will be no maximum.

step (int or None)

The stepping interval in days. If this is None (default), the step will be 1 day.

Examples

from datetime import date
import pandas as pd
import streamlit as st

data_df = pd.DataFrame(
    {
        "birthday": [
            date(1980, 1, 1),
            date(1990, 5, 3),
            date(1974, 5, 19),
            date(2001, 8, 17),
        ]
    }
)

st.data_editor(
    data_df,
    column_config={
        "birthday": st.column_config.DateColumn(
            "Birthday",
            min_value=date(1900, 1, 1),
            max_value=date(2005, 1, 1),
            format="DD.MM.YYYY",
            step=1,
        ),
    },
    hide_index=True,
)
forum

Still have questions?

Our forums are full of helpful information and Streamlit experts.