Formula and dates
Patricia Worth
✭✭✭
Hi all
I have a date column that is a formula (10/12/18 + 60 = 12/11/18) I need to add 6 months to that date, but when i try to add 182 to the 12/11/18 date i get Invalid Column Value. What am i doing wrong?
Comments
-
It sounds like your column property is set to Text/Number. If you click the arrow underneath the column header it should say Current type: Date at the bottom. If it doesn't you can Edit Column Properties there.
-
figured it out... the column was not a date column... all good now.. thank you!
