[Scripr runner cloud] Get quarter of the year based on date

Sebastian Krzewiński

Hi!

 

Is there any way to get quarter of the year based on date in script runner?

I can set format for year/month/date like year=today.format("YYYY") and maybe there is something like quater=today.format("Q").

 

Regards,

Seba

Sean Chua _Adaptavist_

Hey @Sebastian Krzewiński ,

I don't think there is a specific one like that, but if you have some kind of logic to define it nicely, it should be possible for you to format it in a way that it looks like "YYYY, QX"

I mean, if you wanted to display it in a scripted field, you could possibly define something like:

    <span>def</span><span> quarter</span>    <span>if</span> <span>(</span><span>month </span><span>>=</span> <span>1</span> <span>&&</span><span> month </span><span><=</span> <span>3</span><span>)</span> <span>{</span>
<span>        quarter </span><span>=</span> <span>"Q1"</span>
    <span>}</span> <span>else</span> <span>if</span> <span>(</span><span>month </span><span>>=</span> <span>4</span> <span>&&</span><span> month </span><span><=</span> <span>6</span><span>)</span> <span>{</span>
<span>        quarter </span><span>=</span> <span>"Q2"</span>
    <span>}</span> <span>else</span> <span>if</span> <span>(</span><span>month </span><span>>=</span> <span>7</span> <span>&&</span><span> month </span><span><=</span> <span>9</span><span>)</span> <span>{</span>
<span>        quarter </span><span>=</span> <span>"Q3"</span>
    <span>}</span> <span>else</span> <span>if</span> <span>(</span><span>month </span><span>>=</span> <span>10</span> <span>&&</span><span> month </span><span><=</span> <span>12</span><span>)</span> <span>{</span>
<span>        quarter </span><span>=</span> <span>"Q4"</span>

 Let me know how that works out for you.

Regards,

Sean