back dated entries not allowed (after 1st submission)

[vicks88980]

Hi,

In colmn, Visit date, I am using in Valid_if ([_THIS] >= TODAY()) to curb  back dated entries.

So in 1st submission there is no problem. But when we edit the entry, it says back dated entries are not allowed (obviously from the formula applied).

So i am looking for :

1. Above formula so that back dated entries are not allowed but...

2. When entry is edited, visit date stays as it is and doesnt throw me the error, if an old entry is edited.

Pls help

[Marc_Dillon]

Use an IF() to determine if your record already exists or not, with IN( [key column] , table[key column] )