I have been struggling with this one for about 8 hours! Please help...

I have a container field that is on a portal row. There is a field on the portal row that has a transaction date. These dates are not always the 1st of the month but the 1st of each month is when tuition is due. I think I need to round each date entry to the first of the month for the calculation for starters. The first line of the script below seems to work. Also I have named the date field "Month" I hope that is not a problem.

What I need is a calculation that will show a global container field when today’s date is 10 days away from the end of the month.

To better describe the scenario...

Dec tuition is on a portal row

Nov tuition is on the row below it

I have gDue on the portal row so that the current month's tuition in the portal row will have a little "Due" graphic on it. The tricky part for me is that I need it to show on the December portal row starting 10 days before December 1st.

Then it would show on the December row each day until today is 10 days before Jan and then it would show on the January row.

Thanks in advance for any ideas you may have. The last failed attempt I came up with is below.

GetAsDate(Date(Month(Month); 1; Year(Month))) = GetAsDate(Date(Month(Get(CurrentDate))+1; -10; Year(Get(CurrentDate))))

; gDue ;nothing)

~ Tyler

Hi Tyler,

Try:

Case ( Get ( CurrentDate ) ≥ YourDueDate - 10 ; Flag )

HTH

Lee

Perfect!

Thanks a million Lee. I knew I had my head wrapped around that one incorrectly!