Make easier the way of manipulating dates

[analorios]

I would really appreciate the implementation of functions to manipulation dates. For example, adding a year, or subtracting “x” years to a determined date. When I have had to implement this, it really took me so much time.

[Roderick]

We are already considering a similar idea found here. 

[Kirk_Masden]

"We are already considering a similar idea found here."  
This doesn't make any sense to me because the thread linked to has nothing to with dates.  Might the URL be wrong?

---

[Rifad]

Not sure if this is delivered but marked as delivered 

[Simon_Robinson]

I agree with this.  All I wanted to do was create a function to say "Calculate the 8th of last month".  It was a nightmare.  Bascially I was trying to split the date up, do Month-1, combine DD/MM/YYYY back together and force it to be recognised as a date.  Would not work.  In the end the only thing that worked was

DATE([Complete])>=
SWITCH(MONTH(Today()),
1,Today()-31,
2,Today()-31,
3,Today()-28,
4,Today()-31,
5,Today()-30,
6,Today()-31,
7,Today()-30,
8,Today()-31,
9,Today()-31,
10,Today()-30,
11,Today()-31,
12,Today()-30,
Today() 
)

Which is very inelegant...