Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get products last change date

How i can get last date when product price was changed ? In this example 13.3.2017

table.png

5 Replies
sunny_talwar

Where are you trying to get this information? Script or front end? Can you share a sample?

Not applicable
Author

Front end.

What i need is straight table. Where is all product, whose price has been changed for more than 30 days ago

sunny_talwar

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

Uploading a Sample

Not applicable
Author

small amount data

sunny_talwar

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.