Date importing in different time zones
|Fri Mar 01 00:00:00 CST 2019|
We are running into other date-time issues in joins because of this based on who imported the file to their system, appended or joined, and then shared the results. We have data sets where the date is displaying as off by one day for one of us, or having problems joining on date because of the 2 hour time difference.
What is the best practice for importing dates when you know you'll be working across time zones? We are currently exploring a workaround to import the dates as nominals and then use the community building block to transform them into RapidMiner dates, but that feels like a clumsy solution.