Your screen shots are no the same. One shows a date range and the other shows an actual date.
I need to insert SaleDate in to those ::DateStart and ::DateEnd fields.
Set Field [DateStart; value: SaleDate] is literally what you asked for, but I am sure that is not what you need.
Yeah the second on (83.1k) was the result from find request in the first one (24.9K). I forgot to say that.
Something like " > SaleDate" and " > SaleDate".
It's typo. Should be " > SaleDate" and " < SaleDate" in ::DateStart and ::DateEnd
I need to find a product that sold during the special incentive period. Each product might have different period, some are until it out of stock, some are just for a few weeks.
Looks like you may want to change how you are doing this. It does not make sense why you would want or need this.
What are ::DateStart and ::DateEnd used for? What is SaleDate?
Simple scripted find.
Or multi key GTRR to get the found set.
Do you need to check one by one or a full found set? I think I recently helped someone with something similar.
::DateStart is the special incentive period starts. ::DateEnd is when the period ends. SaleDate is when a product is sold.
If a salesperson sells STM Charging Cable during Jun 7, 2017 to Jun 15, 2017, the salesperson would get $1 for each cable he is able to sell on top of a normal rate commission. But if there are some cables that are sold after Jun 15, the salesperson wouldn't get that $1.
If that's clearer?
Thank you for the replies