Apparently no one wanted to mention the problem with storing calculated values.
Rather than storing a value from another table, the best solution is to get it when you need it. That way you won't run into data anomalies when the date changes but your update query hasn't run.
Please do some reading on normalization to gain an understanding of the issues.