Get min and max possible value in specific field based on current selections

[#1]

Hi,

I was wondering if it is possible to get the minimum and the maximum possible value in a specific field (in which no selections have been made), based on applied filters on other fields.

Attached an example. The goal is to obtain the value 2014/03/01 for min and 2014/10/01 for max.

I tried with FieldValue, but that did not work as expected.

e.g. ='Lowest possible date value: '  &min(FieldValue(Date,1))

All suggestions are welcome!

Regards,

Maarten

[sebastianlettner · Accepted solution]

Hi,

the problem was, that Date was not a Date value.

Take a look an the script. Now Date is a Dual value so you can use the Max/Min function

[awhitfield]

Hi Maarten,

see attached version using a "real Calendar", works as expected with min and max

Regards

Andy

[#4]

Dear Sebastian,

Dear Andrew,

Thanks a lot! Didn't guess it was that simple... but seems indeed to solve the problem.

At a certain point one is no longer taking a look at the basics... . Luckily your focus was still very sharp

Have a nice day!

Maarten

[awhitfield]

No Problem,

it's very easy to make things too complicated and miss the obvious !

You have a good day too!

Regards

Andy