Microsoft query - rename a column

[ChesterKaup]

I have the following in formula in a Microsoft query. The formula works fine. I would like to rename the column so it displays as a name rather than the formula.

DateDiff(Day,ProdPattern.ProductionMonth,DateAdd(Month,1,ProdPattern.ProductionMonth))

I have tried DateDiff(Day,ProdPattern.ProductionMonth,DateAdd(Month,1,Prodpattern.ProductionMonth)) as Days but that does not work. I also tried words other than days in case days is a reserved word. What is the way to do this?

 

[Fazza]

please try enclosing the name in brackets, untested. That is, formula AS [Days]

 

[Marbles]

YourName:DateDiff(Day,ProdPattern.ProductionMonth,DateAdd(Month,1,ProdPattern.ProductionMonth))