Formula to Identify First Date in a Field

Question

I'm not sure this is possible in a formula.

Is there a formula I could use that would return the first or earliest date in a field full of dates?

I am trying to create an output filename and I'd like to have first date and last date for the data.

Usually I use current day or First of month, etc..  ie: \REACTIVE OUTPUT\"+[ConsolidatedMaster]+" - REACTIVE -"+DateTimeToday()+".xlsx|||test$A1:M1"

In this case I dont want today's date

briankuhlmann · Answer

I figured this was my only option, thanks!

Luke_C · Answer

Hi @briankuhlmann

Use a summarize tool to find the Minimum date. You can then use an append fields tool to bring that value in for all records in order to leverage it in your file name formula

MilindG · Answer

Would Max or Min date work?