Forum Discussion
Tihannah
4 years agoResolver II
Filtering based on Date Selection
Let's say I have a load of fruit and the dates we stopped stocking them in addition to current in a Fruit Dimension table. Apples -removed 1/15/22 Oranges - removed 3/5/22 Grapes - removed 4/11/22...
- 4 years ago
I was able to resolve this adding a Max Date for the Month of Date Removed and then a Flag if Date Removed was >= the Max Date. I then filtered on the Flag. Thanks.
Tihannah
4 years agoResolver II
I was able to resolve this adding a Max Date for the Month of Date Removed and then a Flag if Date Removed was >= the Max Date. I then filtered on the Flag. Thanks.