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.
Page 1 / 1
The DateDifferenceCalculator (FME Store) maybe satisfies your requirement.
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?
Wow David, that is exactly what I was looking for. I should check the FME store more often.
Might be good idea to add this functionality to the new AttributeManager as it creates a new attribute.
We've got big plans for dates in FME 2016.1....
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.
Units to agree with Esri's time module would be handy:
http://desktop.arcgis.com/en/desktop/latest/analyz...
Would you believe FME 2017.0
ahh ESRi time...
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.
Dates before 1900 need to be handled. Sqlite date function uses Julian dates back to 4000 BC.
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.
This has been released as part of FME 2017.0 . Visit http://www.safe.com/downloads to download and give it a spin.