Interactions are created with incorrect date

Sometimes Interactions are created by Account Data Upload (ADU) with the date of the upload instead of the uploaded date.
To resolve the issue, here are the steps to follow:

1.  Look at the Uploaded Date values in UL_Interactions:
Select * from UL_Interactions Where Process_ID = <process id>
2.  Make sure that the uploaded date values are in the correct format, based upon the Vendor date format:
Select * from Vendor_Date_Formats where Vendor_Code = <upload_file_code>
3.  If the data does not match the Vendor date formats, then alter either the data or the vendor date formats in order to make them match.

4.  One possible cause for data being in the wrong format is that a file created from Excel drops the leading zeros. This can be fixed by using a different column format in Excel.

Environment

 Team Approach
 RSR
 TA

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.