Forum Discussion
Transformation to Add Days
Guys, what is wrong with this syntax please? It doesn't generate error but it doesn't make the needed transformation either. What I need to do is to add 1 day over the dates (by transformation not...
Please try this instead
= Table.TransformColumns(#"Changed Type",{{"Hiring Effective Date", each Date.AddDays([Hiring Effective Date],1), type date}})
Pat
I'm afraid it got me an error now: