Add row if condition question

[JCSF_JCSF]

Hi,

I’m trying to create a rule that only allows a user to add a new row to a table if the value of a column of the form ( a date value) is less than NOW()-3.
Any help?

[Lynn]

Hi @JCSF_JCSF Do you want to use Date or Date time? You may need to use TODAY() rather than NOW()

[JCSF_JCSF]

I am using datetime, but when add [datetime_column] > (NOW() - 3)
to the add action behaviour the “plus sign” simply desapears…

[JCSF_JCSF]

I managed to do it in another way:
I set a valid if condition in the column, and it displays a invalid message if the date is less than NOW()-3.
Thanks!