Anniversary by Month and Day

[Llaamaboy]

I need to come up with a list based on Month and day excluding the year.

For example, list all loops establised in June (regardless of what year) and sort by day.

In my current Excel sheet, I have a column with a number manually inputed based on month day - 102 for Jan 2nd and 1212 for Dec 12th, and sort on that number to get the set of records I need. However, that is not very, well, cool database design, but my knowledge of scripting is still on chapter 5.

I do not mind swimming up stream to figure it out, so any help would b appreciated.

[ESpringer]

Suppose your date field is called WholeDate

Then you want a calculated field,

Month(WholeDate)

and a Global field in which to put the number of the month desired in the current report (June as 6, say).

Then build a relation matching the global field and the Month field. All records in that new Table Occurrence will be of the desired month.

You can just sort on WholeDate once you have the set you want; no need to include the day info anywhere extra.

[Llaamaboy]

Wow ... thanks!

And the best part, I think I understand it.