Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Creative Editor
-
Labels:None
-
Environment:
Operating System: All
Platform: PC
-
Bugzilla Id:1253
Description
Process:
1. Download a group file with the intent to edit the END DATE.
2. Open in Excel.
3. Make Changes to END DATE.
4. Upload file.
5. Get Error: Invalid Date Format
Troubleshooting:
Opened Text file after download:
- Date format is yyyy-mm-dd
Opened Text file after Excel touched it:
- Date format is mm/dd/yyyy
- Needed to select column or field and change the date format to a CUSTOM date
format of yyyy-mm-dd.
Conclusion:
Application should parse any date format. This can be fixed in the following file:
secontentmsngroupcsvfilereader.class.php
applyCustomDataFilters() method
If strtotime() fails it could be because the date in the file is past the
maximum date supported by php (04:14, 19 January 2038). This is only an issue if
PHP is using 32-bit timestamps. If it does fail, the date could be truncated to
the max date (but account managers should be using the "no end date" feature
rather than setting the date way in the future).