Date expressions (today / between)

[michak80]

Hello, 

I have created table and I need recieve data:

1) (DIMENSION) In first tabel I need to recieve only activities done today. This is what I have now (=ITL_DATA_DATE)

I try this =if (match (ITL_DATA_DAY, '2021-01-04'),ITL_DATA_DAY) but of course tommorow it will not be work. I also tried 'today()' insted of 2021-01-04 but it doesn't work 

2) (MESSAURE) I need to recieve quantity of orders cretaed between yesterday 13:00 and today 13:00. This is what I have no Count({<OH_ORDER_TYPE = {P}>}distinct ITL_ORDER_ID) but I see all orders create today (from 00:00). 

Today I need to see all orders created between 2021-10-03 01:00 PM and 2021-10-04 01:00 PM

Tomorow the same but created between 2021-10-04 01:00 PM and 2021-10-05 01:00 PM

... 

Could you please help me? Thank you in advance.