Save the Date for Quality Data: Making Use of DateTime
Date, time, and time zone fields can all hold as much value as the data itself. This information can be of further value when you extract and transform it to meet data requirements for your BI or CRM tools.
The problem is, “datetimes” are more complicated than you might think. Different formats need different structures, plus there are time zones to take into account, leap years, daylight savings time, and the dreaded international dateline! All of this can lead to a lot of manual effort (like python coding) for a seemingly simple task.
With FME, you can gain a complete understanding and have control over the datetimes in your data. Our datetime “Transformers” eliminate the need for coding and put you in control of data transformation and automation, all with the click of a button.
Join us to learn how you can use FME’s comprehensive datetime library, including:
- Managing date and time attributes (aka. DateTimes) using FME transformers and built-in functions.
- Calculating differences and testing datetime fields
- Parsing and formatting
- Dealing with different time zones
- How to manipulate date, time, and datetime values
By understanding how to apply the power of FME Engine to datetimes you can improve data quality and ultimately, clock out quicker!