Need help Sorting By Date Using a Formula

[cwoelfe]

Ok i need to create a report that tells me what withdrawals are going to be
refunded at what percentage..

I have a field called REG_AUDIT_DATE this date is the date on which they
withdrew...

I also have a column called TERM_YYT... it is the term & semester of the
class... Each semester has different dates for the refund percentage so I
think I will have to create a different report for each semester...

Anyways, the main thing is that I need to find any withdrawals that fall in
between certain dates and group them...

IE... in term 092 the percentage dates are as follows...

If you withdraw by:

May 12 = 100% refund
May 13 = 90% refund
May 14-15 = 50% refund
May 16-19 = 25% refund


So what would the expression be to find dates in the REG_AUDIT_DATE and
group them according to those dates?

Thanks so much for any help!!!!!

 

[Klatuu]

Use the sorting and grouping in the report to group by dates.
You do not need a report for each semester. You can get the user to enter
the semester and perhaps year on a form and let the report fill in the dates
for the selected semester. I don't know your data, but I would think you
might need a table that has the year, semester, and dates to identify them.