I’ve created a report which shows a list of dates along with currency values and whether or not the value for that date is unbilled. The three columns are made up of a date field, a currency field, and a variable to determine whether it is an unbilled item.

e.g.

23/09/13 - £100 -
09/12/13 - £100 -
11/12/13 - £100 -
06/01/14 - £100 - Unbilled
27/01/14 - £100 - Unbilled
05/02/14 - £100 – Unbilled
26/02/14 - £100 - Unbilled

I’m having difficulty coming up with a formula that will show the date of the oldest unbilled item.

I would normally use the ‘Minimum’ command to obtain the oldest date however in the example list above, the Minimum/oldest date is 23/09/13 whereas I need the oldest unbilled date which is 06/01/14.

Can anyone offer any pointers as to how I could pick out the oldest unbilled date?

Thanks in advance.

you could create a formula like
maximum(date_field)