Date in Q1 - 12/13 format

[damipera]

hi guys, can you give me an idea as to how i'd convert a date(January 1, 2012) into this format, example: Quarter1 - 12/13

thanks for any help

 

[Geates]

[tt]cint(month(date) / 4) + 1[/tt] will give you the quarter. [tt]right(year(date), 2)[/tt] will give you a 2 digit year.

-Geates


"I hope I can chill and see the change - stop the bleed inside and feel again. Cut the chain of lies you've been feeding my veins; I've got nothing to say to you!"
-Infected Mushroom

"I do not offer answers, only considerations."
- Geates's Disclaimer

 

[SkipVought]

???
[tt]
Quarter1 - 12/[highlight]13[/highlight]
[/tt]
[highlight]???[/highlight]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Geates]

Yeah, what is 12/13?

-Geates

"I hope I can chill and see the change - stop the bleed inside and feel again. Cut the chain of lies you've been feeding my veins; I've got nothing to say to you!"
-Infected Mushroom

"I do not offer answers, only considerations."
- Geates's Disclaimer

 

[SkipVought]

1. By definition, a QUARTER is ONE FOURTH of ONE YEAR.

Your example equated 1/1/2012 as quarter 1, which would imply that the quarter relates specifically to 2012 and has absolutely NOTHING to do with 2013.

So please explain what [highlight]/13[/highlight] is supposed to signify?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}