### Title

Calculation based on Date Range

### Post

I know there are a lot of threads out there relating to Date Range Calculations but I couldn't quite find the one to help me.

I have a portal where each row is a new record that has a Date field and Number field on it. The calculation I need is just to subtract the Number field between two dates that will be selected. What is the best way to acheive this? I am aware that I will need 2 global fields, start date and end date but I am not sure how to link those global fields to the Date field in the portal so when selected will choose the Number values corresponding to those dates. How would I then write the calculation?

Any help would be appreciated.

Will the two pertinent dates be the dates in your global fields?

If there are a number of dates, how will the dates of interest be selected?

If these are the dates in your global fields, you would make two table occurences, each liinked to a different global field (Global1 = TO1), (Global 2 = TO2) then use the calc in the form of

TO2::number - TO1::number