first record of each year Script

[rivet]

I have a list of records with a date in each record.

I would like to create a script that finds the first record of each year and tag it.

(currently there 1097 records covering eleven years, and the tag can be a simple boolean)

anyone?

[Kundinger]

Hi 'rivet',

Quick & Easy solution...

create a looping script

find each year

sort date & time

mark (tag) first record

continue loop

Hope this help!!!

Bob Kundinger

[email protected]

[Charles Delfs]

or you can:

create a calulation of the year(only) of your date

create a self-relationship based on you new yearCalc date and sorted by the date

then create a calc that checks if the recordID via your new relationship equals the currect RecordID then return true else false

This no looping is required and you can perform finds.

Charles