Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 7000 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

This topic is 7000 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.