Skip to Content
-1
Sep 13, 2023 at 12:43 PM

Displaying a date

56 Views Last edit Sep 13, 2023 at 03:19 PM 2 rev

I need to display the dates in the AY columns. The Start Dt and End Dt is the dates the project is valid for.

Our organizations AY dates are 09/01 (Sept 01) through 08/31 (Aug 31).

If the project valid dates start within the Current AY, I need to display the Start Dt through the last day of the AY, unless the End Dt is before the last day of the AY.

AY 2022 dates are 09/01/2021 - 08/31/2022; AY 2023 dates are 09/01/2022 - 08/31/2023; AY 2024 dates are 09/01/2023 - 08/31/2024;

In row 1, AY 2022 should display 9/1/2021 (first day of AY 2022) - 03/31/2022 (End Dt), as start date is in a prior AY not being displayed.

In row 2, AY 2022 should display 4/1/2022 (Start Dt) - 08/31/2022 (last day of AY 2022); AY 2023 should display 9/1/2022 (first day of AY 2023) - 03/31/2023 (End Dt).

Etc.

image.png

Thank you in advance for any insight on how to fix this.

Attachments

image.png (40.9 kB)