Replicate formula to display last x days

Hi,

We use a replicate formula between two servers to display only last 3 days memos.

It works only if the memo has not been replayed or forwarded. If so, the memo replicate but newer disapear from the replicate even if we change the formula to replicate nothing.

Tank’s for your help.

Subject: Replicate formula to display last x days

Greg,

I would like to help, if you are needing help. Is this a question, are you saying you WANT to use a replication formula to do this?

Also, I don’t understand what you mean by the last part. I am guessing, just guessing, that it is your English that is the problem, and if so, I will try to work through that. However, please try to explain this in more detail.

Thanks.

  • Matt

Subject: RE: Replicate formula to display last x days

Matt,Sorry for my english. The problem is not only my English but

also the behavior of a replication.

We use the following replicate formula to keep only the last 3 days documents.

SELECT Form=“Memo”:“Reply” @Created > @Adjust(@Now;0;0;- 3;0;0;0)

At the first replication, the result is as expected. We have only memos for last 3 days.

But then, if we reply or forward to one of these memos (source db or target db), these memos do not leave any more the replicate even after 3 days!