Text for past and Date for present and future

[joshua1990]

Hi all!

I have a column with a lot of dates. Now I would like to add a calculated column that displays "Past" if the Date if in the past. If the date is today or in the future, I would like to see the Date.

How would you do that?

[FreemanZ · Accepted solution]

hi @joshua1990 

try to add a column like:

Column = IF([Date]<TODAY(), "Past", FORMAT([Date], "m/d/yyyy" ))

it worked like:

the sequence of "m/d/yyyy" depends on your preference.

[ValtteriN]

Hi,

This should do the trick: 

Past = IF([Date]<TODAY(),"Past",FORMAT([Date],"DD-MM-YYYY"))

Here I am using format to avoid "variant type data" error:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/