Working with datetime

When encountering a scenario with datetime fields/columns make sure that the datetime format is setup in a way that the output writer will accept the datetime values depending.

Using the DateTimeConverter transformer - here is FME documentation on how it is used.

Reader Format	Input type	Output (CSV/Excel)	Output (Socrata)
Esri SDE database	Auto detect FME and ISO format	%m/%d/%Y	ISO (auto format)
Socrata	Auto detect FME and ISO format		ISO (auto format)
Socrata (Legacy)	Auto detect FME and ISO format	%m/%d/%Y	ISO (auto format)

Generally "Allow null/missing/empty values" in the transformer so those values don't get sent to the <Rejected> output port. Unless the FME user wants those values separated in a different output port.

Socrata (Tyler) Writer in FME and Socrata set-up

The setting on the writer for datetime is auto-detected as text. the first time it is published. The publish setting is Replace | Use Existing.

After publishing the dataset the first time, you will have to manually change the date type from Edit > Review and Configure Data.

Change the datetime column from Text to Date & Time through Socrata the click OK > Update.

After that is done, change the FME writer setting to:

From Replace | Use Existing to Replace | Truncate