I need to write some calculated values to the internal Zenon archive with past (day, month, year ago) or future timestamps randomly. For example, I need to calculate the effectiveness for the period 3 months ago (when I receive feedback data) and show it on the trend correctly.

Is it possible or do I need to use SQL server only?