Skip to Content
0
Jun 23 at 05:59 AM

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

52 Views

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.