I set this simple replication formula in a users mail database:
SELECT @Created = @Adjust(Date;0;0;-30;0;0;0)
It worked the first time, replicating only the last 30 days of document to his local mail file.
Now he wants 60 days, but changing the formula does not change the result; the database still only replicates the last 30 days. I’ve tried clearing the replication history, but no effect. Do I have to delete the local replica and start over every time I want to change the replication formula?
Subject: Simple replication formula
Where is “Date” getting it’s value? There is no “Date” field on documents in a mail file unless you are setting it. Also, your formula will only replicate docs that are exactly 30 days old. If you want all docs that are less than or equal to 30 days old then you would need this:
SELECT @Created <= @Adjust(Date;0;0;-30;0;0;0)
For 60 days try
SELECT @Created < @Adjust(@Today;0;0;-61;0;0;0)
Subject: RE: Simple replication formula
Right. How silly of me. I was confusing Date and Today!! Thanks for your help. But your operator was facing the wrong way. It should be like this:
SELECT @Created > @Adjust(@Today;0;0;-61;0;0;0)
if I want documents created within the last 60 days.
Thanks again.