How can I do the calculated date in the dw with Computed field.
I have a Computed Field where I calculate the number of months the item expire in.
Now, based on that I need to report the month when the part expire.
Remaining Hours 400
Remaining Months 400/180 ( 180 часов в месяц хардкодед)= 2
Expire Months 2
Expire Date needed Todays date + 2 months = August, 2006...
How to do the calculations for the date.
In SQL I could do the Dateadd, but how do I do that in Dw.