Academic Year: Calculates the academic semester and year based on the report date generated by the pipeline.
- In Quickbase, go to the table where you want to add the calculated semester and year field.
- Click on "Customize Fields."
- Create a new text field or edit an existing one.
- In the "Formula" section, paste the formula you copied above.
- Replace [Report Date] with the actual name of your field containing the report dates.
- Save the field. This formula will automatically categorize your report dates into semesters and corresponding academic years based on the month of the report date.