[Stackoverflow] [Progress OpenEdge ABL] Getting Current "Effective-date"

Status
Not open for further replies.
K

Ken Goist

Guest
I have a table that is storing pricing with an effective-date, but no end-date. I need to get the pricing for the most recent effective date and I have been struggling to find a solution in CR2016. Below I am providing an example of two SKU's with different effective dates and they also have a Future date.

Data example:​

SKU - Effective date - Price​


SKU1 - 2/1/2021 - 415.00 (Old Price)

SKU1 - 4/15/2021 - 425.00 (Current Price)**

SKU1 - 8/1/2021 - 435.00 (Future Price)


SKU2 - 1/1/2020 - 125.00 (Old Price)

SKU2 - 6/1/2020 - 150.00 (Old Price)

SKU2 - 12/1/2020 - 155.00 (Current Price)**

SKU2 - 8/1/2021 - 175.00 (Future Price)

SKU2 - 1/1/2022 - 200.00 (Future Price)


You will notice above, that the current pricing may have a different effective date and there may or may not be one or more future price effective dates. What is the best way to pull the current price for every Sku in my DB using Crystal Reports 2016?

Continue reading...
 
Status
Not open for further replies.
Top