--- 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 canonical: "kb.pigment.com/min-function-timedate" --- > ## 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!