I have an AGOL feature layer with a DateOnly field that I am trying to filter out the last 365 days worth of data. Is there an easy way to complete this?
The data is formatted in the following way:
2021-01-01
Solved
Filter last year's worth of data
+4- Contributor
Best answer by crutledge
Hi
You could use a tester or filter and use the DateTimeDiff() function to calculate the time interval in days and then filter greater than / less than 365.
Hope that helps!
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.
+47- Influencer
- Best Answer
Hi
You could use a tester or filter and use the DateTimeDiff() function to calculate the time interval in days and then filter greater than / less than 365.
Hope that helps!
+73- Celebrity
An approach I really like when dealing with more complex date/time filtering (
Firstly, convert the dates into epochs (seconds since 1/1/1970) then using a VertexReplacer, use the epoch as the X value (set the Y to zero).
This now give you each feature as point along a date/time continuim.
If you have a data range you want to filter, use a similar approach, but create a line instead. You can then use spatial tools to find point on the line, spatial group the point etc.
As someone who often struggles with date/times (especially with timezones) this apporach has been really helpful (original credit, many years ago, to
+4- Contributor
Hi
You could use a tester or filter and use the DateTimeDiff() function to calculate the time interval in days and then filter greater than / less than 365.
Hope that helps!
Hi
I ended up using this exact approach to solve the issue! I’m glad I was on the right track. Thanks for the quick reply!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.