Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning guys
If I have two list boxes, one each for "Year" and "Month", how would I write an expression that would return either the min or max dates of my selection combination.
I.e if I have 2016, and January selected, how would I return 01/01/2016 and 31/01/2016?
Many thanks,
Gareth
then use below, in two variable
MinVariable
=monthstart(floor(date#(max(Year)&max(Month),'YYYYMMM')))
MaxVariable
=monthend(floor(date#(max(Year)&max(Month),'YYYYMMM')))
Sorry to be a pain, but how would I write an expression using these to count the dates in a field that fall between the range specified (using these two expressions)?