Date as a quarter with year

[CharlesFowler72]

Hi guys,

trying to get a date into a quarter format exactly like this..."Q1'19".

I'm pretty close with Quarter = Cat("Q",qtr(month),"'",year(month)) where month is my date variable.

But this gives Q1'2019 which is close but not quite there.

any help would be great. There is lots on the site already about this stuff but none did exactly this.

[Astounding]

Well, you could change this:

year(month)

Just use this instead:

year(month) - 2000

[Reeza · Accepted solution]

SUBSTRN() will allow you to substring a character variable.

SUBSTRN(year(month), 3, 2) will give you the last two digits. You may also want to explore a custom format. That's an easier solution overall.