DATEADD - can the output just be MMM YY

Formulas
1

Hi, I have this formula;

DATEADD({REVIEWED ON}, 1, “year”)

I want the output to be just MMM YY but that’s not available in the list of options for formatting the field. I am currently getting DD MMM YY.

Can this be achieved in the formula itself? I am self-hosted.

Thanks,

Ian

2

Yes, this can absolutely be achieved in the formula itself. You’ll need to use MONTH() and YEAR() functions combined with a SWITCH statement to convert the month number to a three-letter abbreviation, then concatenate it with the year.

Here’s a formula that will give you “MMM YY” format:

CONCAT(
SWITCH(
MONTH(DATEADD({REVIEWED ON}, 1, “year”)),
1, “Jan”,
2, “Feb”,
3, “Mar”,
4, “Apr”,
5, “May”,
6, “Jun”,
7, “Jul”,
8, “Aug”,
9, “Sep”,
10, “Oct”,
11, “Nov”,
12, “Dec”,
“”
),
" ",
RIGHT(YEAR(DATEADD({REVIEWED ON}, 1, “year”)), 2)
)

This formula:

  1. Uses DATEADD to add 1 year to your REVIEWED ON date

  2. Extracts the month number with MONTH() and converts it to a 3-letter abbreviation using SWITCH

  3. Extracts the year with YEAR() and uses RIGHT(..., 2) to get just the last two digits

  4. Concatenates them with a space in between

The output will be something like “Mar 26” or “Nov 25”.

This is answer is from AI support