Set Field [ target field: YourTable::yourField ; calculated result: List ( YourTable::yourField ; Get ( CurrentDate ) ) ]
I try this and get need insert operator here
this is what I have
Pantry Helper::Last Recived food: ; Get ( CurrentDate )
I believe you missed the word "List" in Erolst's post.
Okay That worked I did miss the word list thanks all for help.
Though you have been provided with a literal answer to the question you asked, I think you may want to consider a different approach. There are a couple of problems with the existing method. One is that the list might get very long, and so you may lose track of the most recent date. One answer to this would be to change your set-field calculation, and always put the new entry at the top.
Set Field [ target field: YourTable::yourField ; calculated result: List ( Get ( CurrentDate ) ; YourTable::yourField ) ]
The better approach would be to create a new table, let's call it member_dates, with a field for memberID and date.
Then you would create a new RECORD in this table every time a person attended. You could view their history in a portal, and if you desired, you can sort the portal by date, showing the most recent record first. There are several other advantages which result from this more normalized approach.