Skip to main content

My table is for students in a tutoring program.  One field is their current grade.  Another is the calculated formula of today's date.  Every August 15th (each year) I want each student's current grade to increase by 1.  Is there a way to do this?

 

Edit - Answer was wrong, deleted

Edit - Answer was wrong, deleted


With this formula, will the grade field automatically increase every August 15th?

With this formula, will the grade field automatically increase every August 15th?


Ah so sorry about that, the formula was flipped around I think

Try having:
1. Date of enrollment
2. Grade at enrollment date
3. Current grade

"Current grade" would be a formula field that would find the year difference between the enrollment date and Aug 15 of this year, resulting in something like this: 

 
Here's the formula I used:

 

{Grade at enrollment} +
DATETIME_DIFF(
{Current Date},
"08/15/" & YEAR({Date of enrollment}),
"years"
) +
1 -
IF(
AND(
IS_BEFORE(
{Current Date},
"08/15/" & YEAR({Current Date})
),
IS_SAME({Current Date}, {Date of enrollment}, 'year')
),
1
)

 

And here's a link to the base

Sorry about that.  I'm actually still not too sure whether this does what you're looking, please let me know if there's something else wrong with it and I'll do what I can to fix it!

Reply


Terms & Conditions