Date math doesn't work with rollup

My app’s URL: app.callthecanman.com
Here’s a video showing the problem: Loom | Free Screen & Video Recording Software

I had a working app that was recently broken by an update. I had a Math column that subtracted

now-date

the date column is a rollup column. If my math column just displays the date, it is shows the date fine, but when I try to modify the date, it does not work. The column is empty. The frustrating thing is that this exact setup was working fine just a week ago. I didn’t change anything, and now it’s broken and I have to fix it. Any work arounds would be much appreciated.

I figured out the problem. Somehow the Date column was not appropriately set. It was a text column. Changing it back to a date column fixed the issue.

1 Like