Hey! I've been troubleshooting an issue with FME for a couple of days and I thought I would reach out to y'all to see if anyone has any insight into the problem. Our office publishes lobbyists datasets to a socrata data portal from tables in an oracle database. We use FME workbench to push the data from oracle to the data portal. The problem is, all of the dates are displayed as one day behind the correct date in oracle. The dates in oracle are stored as a Date/Time value and I've fiddled with the date formatter in FME, but no such luck on resolving the issue. I noticed that the dates in the data portal are stored as Date/Time (with timezones), so I have a theory that the issue has to do with timezones, but I can’t figure out to switch the socrata column’s data type to Date/Time in FME. Does anyone have a suggestions or advice? Thanks!
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
HI @gracekretschmer,
You should be able to change the attribute type to date in the Writer Parameters under User Attributes. Check 'manual' as the Attribute Definition if it is not already and then 'date' is an option from the Type drop down menu.
