I’d have to check how dynamic it is again, but date columns are actually pretty powerful. If you write the text value of ‘Tuesday at 9:00am’ or ‘Next Tuesday at 9:00am’, it will magically figure out the date. The part I’m not completely clear on is if it will dynamically update the date after each date has passed, or if it becomes static.
Some reference:
@robert states it’s dynamic but maybe found a workaround:
Just some quick testing, when writing text in a date column and then changing it to a text column, it seems to hold it as a static date without time, but somehow retains the time. When writing text in a text column and then changing it to a date column, it seems to hold the text which converts dynamically to the correct date. Again, I’m not completely sure what the behavior will be, but that might be one way to have dynamically changing dates.