Question

Test for oldest date?

  • 16 September 2016
  • 2 replies
  • 4 views

Badge

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.


2 replies

Badge +16

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.

Badge

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

 

Reply