This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using SharePoint list Input tool to input the SharePoint list data and sending that to Oracle database using output data tool. Workflow is working fine but when i checked the data in Oracle database i have observed that all records wherever we have date information is showing it as 1 day prior, Means if date in SharePoint List is 02JAN2019, in output it is showing it as 01JAN2019. this is the same case for all records and all columns wherever we have date. I have scheduled the job in Gallery and tried got same output. I am not sure what is the issue. request you to please help me to solve this error.
If the date functions used are in different time zones, this can happen. You might need to adjust for the timezone differences by use of a function like: DateTimeADD() where you either add a whole day or the number of hours.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.