Forecast Query with stepwise increasing year

[theracer06]

Hi,

I am building a Query that multiplies a price curve for every hour in the
year by a constant so as to build a multiyear forecast curve.

The only glitch is that I do not know how to make the date function update to
the new year after a full 365 round has been multiplied.



Does anybody know how to make Date change from 31/24/20xx to 01/01/20xx+1?

Thanks in advance and Best,
Leo

[NTC]

one approach using the DateAdd method one can roll forward to new days, months, years....if you are not familiar with it - look it up in the VBA Help....