Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How i can get last date when product price was changed ? In this example 13.3.2017
Where are you trying to get this information? Script or front end? Can you share a sample?
Front end.
What i need is straight table. Where is all product, whose price has been changed for more than 30 days ago
It might be easier if we can have a sample to play around with... would you be able to share a sample?
Preparing examples for Upload - Reduction and Data Scrambling
small amount data
Check the attached... I had to create a link table because the Date was not sorted in the ascending order of date... if you can sort it before hand in your qvd or create a master calendar before your load your qvd... this might work without the link table.