Date settings, quarter

[Malgorzata_Niteckakubicka]

Hi,

I have to type a proper date range into SAP.
And I need to always set a range which is a quarter
Example
if we have 09.12.2021 → quarter 4
01.10.2021 - 31.12.2021
if we have 03.04.2021 → quarter 1
01.01.2021 - 31.03.2021
How can I do it in StudioX?

[pikorpa (Piotr Kołakowski)]

Hey,
try something like this:

month = DateTime.Today.Month → integer
(Math.Floor((month-1)/3)+1) → quarter

[Malgorzata_Niteckakubicka]

In StudioX it seems to be not that easy

[pikorpa (Piotr Kołakowski)]

If you are using write line activity you have to use (Math.Floor((month-1)/3)+1).tostring3

/edit. Sorry You’re right. In studioX it doesn’t work. I will take a look and will let you know.

[pikorpa (Piotr Kołakowski)]

@pikorpa

(Math.Floor((month-1)/3)+1)

Hey,
now it’s works:

NewBlankTask.zip (49.3 KB)

[Malgorzata_Niteckakubicka]

@pikorpa

integer

Hi
Yes it is working!
and one more small question

I have to find a current year but be able to use this value later on. As for now Var3 can not be used inside Type in or Write line because it is Int how to have a String

[pikorpa (Piotr Kołakowski)]

When you using ‘save for later’ activity - click plus button and choose number as type of variable.
And it’s works fine