COLUMN - IF THEN TODAY's DATE

Ask for Help
1

Situation: Have a date Column with a value. If this value has past, I need to call Today’s Date instead.

Solution:? I’m thinking the way to do this is an IF THEN column that sets to Today’s Date IF the date column is earlier than Today (you can set this criteria in IF THEN)

However: I can’t find a way to set the value upon this condition to today’s date. Perhaps I’m missing something here.

2

You’ll need another math column that outputs today’s Date (Now) and use that in the ITE column.

3 Likes
3

Thanks - that works.

A little bit of a round about way with additional columns - but I’m coming to understand this is the default approach in glide to resolve these issues. AKA add another column.

3 Likes
4

4 Likes