Quite often I need to calculate the difference between two dates. The result can be needed in days, hours, minutes or formatted like a date.
This is hard to accomplish in FME.
A DateCalculator transformer would resolve this.
Released
Date calculator transformer
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.
+21- Contributor
Hi Erik - there's a DateDifferenceCalculator in the FME Store originally created by Iris Gutowski, its awesome and I use it quite a lot. Is this the droid you've been looking for?
+26- Contributor
Wow David, that is exactly what I was looking for. I should check the FME store more often.
+26- Contributor
Might be good idea to add this functionality to the new AttributeManager as it creates a new attribute.
+22- Contributor
I think it's better to add a DateAdd function just like the one in T-SQL so you can use the function anywhere in the transformers.
+19- Influencer
Units to agree with Esri's time module would be handy:
- Contributor
I often need to calculate the age of some asset in years from usually todays date. Adding years as opposed to days would be great.
+10- Contributor
Dates before 1900 need to be handled. Sqlite date function uses Julian dates back to 4000 BC.
+22- Safer
There is a DateTimeCalculator in FME 2017 which is currently available as a Release Candidate on our downloads page. We'd love to have feedback on this before the release.
+1This has been released as part of FME 2017.0 . Visit http://www.safe.com/downloads to download and give it a spin.