Skip to main content
Question

Test for oldest date?

  • September 16, 2016
  • 2 replies
  • 104 views
cwarren
Forum|alt.badge.img

I have two different "groups" of point features that are all in close proximity to one another. I need to only pass one point feature from each "group" that have the oldest date and contain 2016 in the attribute STD_COLLECT_TIME. This attribute is in "%m/%d/%Y" "%l:%M:%S" "%p" format.

Any help would be greatly appreciated. See images below for reference.

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.

2 replies

itay
Supporter
Forum|alt.badge.img+19
  • itaySupporter
  • Supporter
  • September 16, 2016

Hi,

Usually sorting and sampling per group can achieve that.

I would format the date using the s epoch, use a sorter on the date and group attributes and sample per group to get just the oldest per group.

Hope this helps.

cwarren
Forum|alt.badge.img
  • cwarren
  • Author
  • September 16, 2016

Hi,

Usually sorting and sampling per group can achieve that.

I would format the date using the s epoch, use a sorter on the date and group attributes and sample per group to get just the oldest per group.

Hope this helps.

Thanks @itay

 

Community Stats

32,899
Posts
124,797
Replies
41,582
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.