Birthday Expression (No Future Dates Allowed)

[Tony_Insua]

I have a Birthday column in a USER PROFILE table. The field type is set to DATE. How do I set it up so that it does not allow for future dates to be selected. Any best practices on how to set this up?
Thanks!

[Steve · Accepted solution]

Set Valid If expression to:

([_THIS] <= TODAY())

[Tony_Insua]

Thanks Steve. Expression makes sense.

Although, I’m hoping to learn more about [_THIS] and [_THISROW] as I feel like I’m not as strong with those particular expressions yet.

[vicks88980]

what if , i want the date to be allowed after 2 days.. Like i have a follow up date column, and i want date+2 days to be filled. Can u pls guide