Changing a date to current date in a found set(list)

[projay]

Whats the best way to change a date in a found set(All Records) to todays date?

-Jay.

[LaRetta]

Hi Jay!

The simplest way would be one script step of: Replace Field Contents [ yourDateField ; Get ( CurrentDate ) ] but, if this is multi-user then you might hit record-locking issues. Replace Field Contents[] will tell you after it finishes that it hit an error and could not set a field (if you trap for the error) but it will not tell you which record didn't set.

On the other hand, you can loop each record setting the value as you go and then you can test that the record set properly. Which would to go would depend upon how often this needs to happen (or is it a one-time thing?), the timeliness (whether the change must take effect immediately or can be ran later), who runs it, the significance of the field being set and so forth ...

Also note that Replace Field Contents[] cannot be undone.