Use case: I convert dates to UNIX seconds (%s) to calculate differences, and then I may need to restore original format of the date attribute.
Archived
DateFormatter: Expose automatically detected source date format
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.
+19- Influencer
Hopefully the forthcoming date-handling improvements in FME 2017 will include a timedelta transformer so this use case will be satisfied.
Hi @crayxt
with FME 2017 DateTimeCalculator, you don't need to convert your dates into UNIX seconds to calculate differences.
I wonder if there are other scenarios where you would need to change datetime format and then restore the original format. In this scenarios, would you know what the original format was? Or would you rely on autodetecting the format?
Thank you in advance for your input.
+22- Supporter
It is not just converting to seconds but using Python caller (to carry out more sophisticated calculations) and formatting the calculated date/time same as the original is also useful to have the recognised format.
Another thing, as I'm aware DateFormatter works per feature. Let's say all locales are set to UK but I get a CSV exported from a system running on a US locale computer. '10/12/11' would be recognised as dd/mm/yy instead of mm/dd/yy but in another row 10/15/11 might be recognised correctly. It would helpful to see the recognised format as a column when debugging