Replacing field contents
I have two date fields in my table. They are to record the date that a customer is sent a letter. The fields are called 'follow_up_date" and 'previous_follow up_date'. The idea is that when I action my print script, Follow up date recieves the get(currentdate). The following week, if i do the same action, I want the data from 'follow_up_date" to copy over to 'previous_follow up_date', and then the field Follow_up_date recieves the get(currentdate) again. Does this make any sense? There may be an easier way around this but unsure..