Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Month(Min( {1} [Invoice Date]))
Month(Min( {1} [Invoice Date]))
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!