Forum Discussion
rocky09
Solution Sage
Solution SageAppending a Column with Yesterdays date
The below is an example of my table. This is basically a stock table (taken for testing purpose). If you look into the last Column LTP i.e today's data. Generally, When I refresh the table tomorrow,...
Rocky,
I think you are over complicating this. The roadblock you are running into is ASSIGNING a time stamp to your data extract from Oracle. When you run your report, is it possible to have Oracle add another column which includes the date that you ran the report? This is pretty common in most reports. So the screenshot you posted had 3 columns. Ideally you would have 4 where the last is the date that the report was ran. Once you can get this, the rest will be easy, you wont even need a seperate "Date table."
rocky09Solution Sage
Solution SageThank you very much for your inputs. After lot of brainstorming. I finally came to a decision to make MS Access is the data source. In my Access, I can easily play with queries to get what I needed.