Find date which is 6 months back from todays date.

[aman]

Hi Guys
I want to find out the last 6 months date from todays date. So as todays date is 27th january 2015 so the code should give me the date which is 6 months back from todays date so it will be something like 27th July 2014.
Any help would be much appreciated.
Thanks

 

[pr2-eugin]

DateAdd function maybe?

? DateAdd("m", -6, Date())
27/07/2014