Pervious 26 weeks from Current date

building semantic layer
1

how to calculate the date of a previous 26 weeks from Current date in SAP IDT

building a universe over HANA database ??

i use function now() to get current date then i dont know how to get pervious weks
I need to calculate the Revenue of previous 26 weeks and do some conditions on it
:hb:

zahmed (BOB member since 2018-01-14)

2

Use this pseudo code to create a filter:

Transaction Date between Today()- 182 and Today()

Adapt it to obay SAP Hana syntax (I don’t have access at the moment)

3

You could probably use the add_days function in HANA to do the same. i.e. add_days(,-182)

ABILtd :uk: (BOB member since 2006-02-08)

4

Thanks :+1:

zahmed (BOB member since 2018-01-14)