Hi anyone knows a good set analysis syntax to calculate a sum on s"date from" ,"date to" fields to get the interval?

[themandrake]

I could use the "slider" function on date but since it is kind of picky to get the selected date down to the date on the slider i choose to have two small multiboxes with two different dates, one is a generated "date from" the other one is the actual date field. on my calculation i have following syntax but it seems not to grip the interval. any suggestions?

sum({$<Date = {">=$(#=(Date_From))=$(#=max(Date))"}>} Value)

[#2 · Accepted solution]

You can try this

Sum({$<Date={'>=$(Date_From) <=Max(Date)'}>} Value)

[themandrake]

Thx  worked like a charm