Hello Everybody,

   Currently I am facing a very weird problem. Here goes the description:

I converted a lead to create an opportunity. One of the field is CloseDate with value as 9/30/2012. The product added to the opportunity has a quarterly schedule. A field called BookedDate contains today's date i.e. 8/17/2012. Opportunity stage is 5- Closed Won.

Now by virtue of a trigger, the schedules should be generated starting from 9/30/2012, however when the CloseDate is updated to today's date and quarterly schedules are generated off today's date, and then again the CloseDate is assigned 9/30/2012 by virtue of a Field Update.

The Opportunity  history shows two entries:

1st) CloseDate changed from 9/30 to 8/17.

2nd) CloseDate changed from 8/17 to 9/30.

Now the most confusing part is the trigger :

It first generates the schedules from 8/17, however due to the update from 8/17 to 9/30 on CloseDate on Opportunity, its logic is not executed. I put a debug log and what it shows for that instance is that the Trigger.new and Trigger.old CloseDate  are the same, which is not true since Old Close Date is 8/17 and New CloseDate is 9/30, but debug log shows New and Old CloseDate as 9/30.

The problem is so confusing that it's difficult to express it right away. Any suggestion would be very helpful.

Thanks a lot.

K