cancel
Showing results for 
Search instead for 
Did you mean: 

calculate number of week of quarter for a given date in sap hana graphical modeling.

former_member379874
Discoverer
0 Kudos

I need to calculate number of week of quarter for a given date in sap hana graphical modeling.

for example: the given input is year - 2022 quarter - Q4 and I have a column in my cal. view as 31.01.2022.

Now I should a get the week number of quarter Q4 of year 2022 for 31.01.2023 is :1.

or

the given input is year - 2022 quarter - Q4 and I have a column in my cal. view as 31.10.2022.

Now I should a get the week number of quarter Q4 of year 2022 for 31.10.2022 is :1.

Can anyone suggest me the logic to be implemented to calculate the above logic.

Thanks in advance.

Abhishek_Hazra
Active Contributor
0 Kudos

For your first example : How does Q4 of 2022 have date 31.01.2022 ?

How does 31.01.2023 belong to Q4 of 2022 & have week number 1?

For your second example : How can 31.10.2022 of Q4 can have week number 1? I can't fit your examples into any sense.

Accepted Solutions (0)

Answers (0)