Hey, i have a question. I have a table with values .. and two variables where i have two dates (a Startdate and an Enddate) - this date i can change everytime and now i want to now the max value from the field "duration" within this two dates. How can i do this? Im very lowskilled in scripting :-(
If i do so, i got an Error (Error in set modifier expression). The Dates in the variables StartDate and EndDate are already in Numberic Format. The Date of the Field (OpenDate) is in the Format 'YYYY-MM-DD'.
According to ur answer the formula should be the following:
I have a last question .. in my diagram i show per Day how much problems were created (For example on 2017-11-11 74 problems were created). Now i want to know within the StartDate and the EndDate the Max Value of Problems per Day.
For example: Within the period of time 2018-01-01 - 2018-01-15 i want to know the Max Problems per Day.