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.
<strong>This post is closed to further activity.</strong><br />
It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br />
If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br />
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?
+18- Contributor
Wow David, that is exactly what I was looking for. I should check the FME store more often.
+18- Contributor
Might be good idea to add this functionality to the new AttributeManager as it creates a new attribute.
+19- 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.
+17- Contributor
Units to agree with Esri's time module would be handy:
+6ahh ESRi time...
- 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.
+19- 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.
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.