In a database I keep a list of dates “(Indiv-Days)”, and assign them a value “(Price)”.
How to know which dates belong to a list (x) and which to another list (y) Selecting a range of dates to calculate its value (price)
Hi Code-escape. I am very grateful for your help!!
I have followed the recommendations and it looks good.
1- I have managed to obtain the list of dates.
** the list of dates.
2- I have managed to obtain the values assigned to the ranges.
** the values assigned to the ranges.
but the problem is that if the range of dates selected in the Date/time Picker contains 2 or more days of a saved range, it only adds 1 time the assigned value.
Whenever I select dates - I only get 1 time the value assigned to the range.
So the problem is that if there are 2 or more dates within my selection, I only get 1 time the value.
You’d be better off following the schema where one date per record instead of a list.
I don’t know Spanish so not sure what’s going on here, but the reason (at least partially) you aren’t seeing the second 300 is because data is being intersected which eliminates duplicates.
1 Like
I’m doing this.
And this is where I only get a value for one day, when that value is assigned to a list of days.
In the example case, I select the days from Monday to Friday and I only get 1 value of -300,
But there must be 2 values of -300, since Thursday and Friday have it assigned
That doesn’t clarify what you are doing. I don’t know what happened to your input R in your last reply but you were intersecting at that point.