Combining power query to change dates

[JamesT23]

Hi 

I want to use PowerQuery to add 11 months to my date and change the format. I can do both individaully using Date.AddMonths and DateTime.ToText but not together. Can someone explain to me how to join the two together.

Thanks 

James 

[parry2k]

@JamesT23 you can call both function in each other

DateTime.ToText(Date.AddMonth(<syntax to add months>))

[JamesT23 · Accepted solution]

Turns out I actually had it correct in the first place, the mistake I made was using DateTime.ToText when i needed to run Date.ToText. Looks like the two had to match. 

[parry2k]

@JamesT23 yes you are right, both has to match. I missed that too. I guess issue is resolved though.