You need to sign in to do that
Don't have an account?
kiran punuru
opportunity billing start date
Hi ,
Iam having one scenario where i need to send reminder mails on friday in which the reminder mail contains all the opportunities satisfying this condition:
[select id,name from opportunity where billingstartdate < today];
on monday i need to update for all the opportunities i have sent on friday but here also we are using same condition to update:
[select id,name from opportunity where billingstartdate < today];
Because we are using the same condition it will update the opportunities having billing start date on friday ,sat,sun .But i need to update for those opps which sended in reminder mail on friday.
If change in the same query will it work ,Any suggestion on this.
Thanks,
kiran
Iam having one scenario where i need to send reminder mails on friday in which the reminder mail contains all the opportunities satisfying this condition:
[select id,name from opportunity where billingstartdate < today];
on monday i need to update for all the opportunities i have sent on friday but here also we are using same condition to update:
[select id,name from opportunity where billingstartdate < today];
Because we are using the same condition it will update the opportunities having billing start date on friday ,sat,sun .But i need to update for those opps which sended in reminder mail on friday.
If change in the same query will it work ,Any suggestion on this.
Thanks,
kiran
Please try this query it may help you.
Here -1 means it will go back to 1 day.
you can use your number to go back number of days.
Please let me Know if it solves your problem.
Best Regards,
Dayakar.D