Member Junction
    Preparing search index...
    ColumnDataType:
        | "string"
        | "number"
        | "date"
        | "dateonly"
        | "boolean"
        | "currency"
        | "percentage"

    Column data type hint for formatting.

    dateonly is a calendar day with no time and no zone (a SQL date column), as distinct from date, which is an instant. The driver delivers a calendar day as UTC midnight, so it is written by its UTC day: YYYY-MM-DD in CSV and JSON (ISO 8601), and a real date cell in Excel.