Formula to find Minimum date value of current month in date field across child objects

I have a Date field which contains, across several child records:

(2014-07-1,2014-07-5,2014-07-8,2014-07-9,2014-08-1,2014-08-5,2014-08-8........), now in these values I want to get the current month(August) minimum date value, that is:
2014-08-1.

How to do this in Formula field?

Answer

I don’t think there’s a formula that could reliably do this, but it could certainly be done with an Apex trigger.

Although it seems like it would be worth separating these date entries into a related custom object & then simply using a Rollup (min) field to find the lowest value in the current month.

Attribution
Source : Link , Question Author : NullReferenceException , Answer Author : Davin Casey

Leave a Comment