SYMPTOM
When a scheduled subscription is sent via Distribution Services to generate a Microsoft Excel file using document with {&DATETIME} autotext, the datetime shown is that of when the document was created, not when the subscription was executed in Strategy 9.x.
If "Send Now" is used, the datetime is the time when the subscription was executed. If the subscription is run off a schedule, the datetime is when the document was created.
STEPS TO REPRODUCE
1. Create a document using the {&DATETIME} autotext.
2. Within Web, create a subscription with an Excel delivery format set on a schedule.
3. Once the subscription has been sent, open the Excel document and see that the datetime is when the document was created.
In this example, the subscription for the document below was sent at "5/18/2012 2:30:00pm."
CAUSE
This is a known issue in Strategy 9.x.
ACTION
Contact Strategy Technical Support for an update on this issue.
WORKAROUND
Use the {&EXECUTIONTIME} autotext which will return the subscription time.
