Formula to Identify First Date in a Field

[briankuhlmann]

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

[MilindG]

Would Max or Min date work?

[Luke_C]

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

[briankuhlmann]

I figured this was my only option, thanks!