And we can add a trigger to replicate date in an history table. Based on that we will be able to retrieve the value easily.