Fixing an expression so the result doesn't change despite selections

[Anonymous]

Hi guys

Can anyone advise me how I would set the below expression to bring the month back from the true minimum invoice date.

For example, a supplier first submitted an invoice in Jun 2014, but if I select 2017 in a list box, the first submitted date changes to Jan 2017. I want the expression to return Jun 2014 no matter what selections I make.

My expression is Month(Min([Invoice Date]))

Many thanks in advance,

Gareth

[tresesco · Accepted solution]

Month(Min( {1} [Invoice Date]))

[Anonymous]

Thank you very much.

I'd seen elsewhere that a "1" was needed, but in terms of the syntax I wasn't sure I'd need to place it.

Thanks again!