---
title: "Use the MIN Function to Return the Smallest Date Value"
slug: "min-function-timedate"
description: "Learn to use the MIN function in Pigment to return the smallest date value across multiple inputs."
updated: 2025-10-29T14:46:20Z
published: 2025-10-29T14:46:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MIN function (Time & Date)

Returns the smallest value among all given values. Data type can be numeric or date.

`MIN(Value1 [, Value2] [, Value3] …)`

Excel: [MIN](https://support.microsoft.com/en-us/office/min-function-61635d12-920f-4ce2-a70f-96f202dcc152)

For more information, see [MIN function (Numeric)](/v1/docs/min-function-numeric).

## See also

Related articles: [MAX](https://community.gopigment.com/functions-84/max-function-151)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!