_How_easy_ would to be to insert today's date if data is entered into a field ? The entered field is AUTHORIZED and the date field is AUTHORIZED DATE. The AUTHORIZED field will be from a POPUP LIST. I can not have the AUTHORIZED DATE entered by default because there will be (2) authorized fields. So once an entry is made I do NOT want to change the date UNLESS the AUTHORIZED field is cleared and re-entered. _ANY_ suggestions are welcomed!!

Philip

Imagine that you have the Authorised field as field 4 and the authorised date as field 5…

Try adding a pre-save process on the window that calls a piece of code (like in the sample below) that checks the original record's (OREC) authorised field (pre-edit) and the current record's (@RECORD) authorised field (post edit), and modifies the date accordingly. You may then protect the date field on the screen against any entry.

$INSERT SYSINCLUDE, AREV.COMMON
* modify date in field 5 to today if field 4 has changed
IF OREC  @RECORD THEN @RECORD=DATE()

The Sprezzatura Group

World Leaders in all things RevSoft

Might want to embellish a little:

If @Record Then

 IF OREC  @RECORD THEN @RECORD=DATE()

end else

 @Record='

End

View this thread on the forum...