What is changing?
Updates are being made to the date formats for 4 fields found in the Opportunity Save History data feed. The new format is 'YYYY-MM-DD HH:MM:SS AM/PM'
- Opportunity Created
- Current Close Date
- Prior Close Date
- Last Modified
Why is it changing?
The changes are being made to support better readability and usage in analyses.
Which datasets are impacted?
- Opportunity Save History
| Field Name | Data Type | Old Format | New Format |
| Opportunity Created | timestamp | YYYY-MM-DDTHH:MM:SS | YYYY-MM-DD HH:MM:SS AM/PM |
| Current Close Date | timestamp | YYYY-MM-DDTHH:MM:SS | YYYY-MM-DD HH:MM:SS AM/PM |
| Prior Close Date | timestamp | YYYY-MM-DDTHH:MM:SS | YYYY-MM-DD HH:MM:SS AM/PM |
| Last Modified | timestamp | YYYY-MM-DDTHH:MM:SS | YYYY-MM-DD HH:MM:SS AM/PM |
How does my bank need to prepare for these changes?
Any downstream processes that utilize the specific formats of the columns need to be changed to support the updates.
When are these changes happening?
These changes will go into effect on Thursday, June 16, 2022.
