I’ve seen this asked before and the answer has been " In a math column, type date + 1 and replace date with the date column." In the resulting math column, I get a number, not a date. What gives?
Your date column is not a true Date type column. The math column is just reading the numbers from your date column as a numeric value, and not a date value.
What type of column is your date column and how is it populated?
1 Like
Thank you. When I switch to the underlying date column, the problem goes away. I’ll add an enhancement request to fix this since the format-date type is implicitly a date.
It’s not technically broken. Format Date returns text. Not a date. If you need the date in a mm/dd/yyyy format, I recommend using a math column that refers to your original date column and set the formatting there to short date. That way it will still be recognized as a true date.
2 Likes