How to get last 10 dates from date field

lakshman1031 · ‎2024-10-03

Hi All,

I have date field OrderDate and I want to see the last 10 dates from date field. if i select any date then i want to see the last 10 records.

I am trying to use max(OrderDate)-10 then I am able to see the last 10 dates Serial.

For example

Orderdate:

I want to see last 10 dates not for serial dates.

Can you please suggest me how to Solve this scenario.

Thanks & Regards,

Lakshman

Chanty4u · ‎2024-10-04

You can try this

Count({<OrderDate={"=OrderDate >= Max(OrderDate)-10 and OrderDate <= Max(OrderDate)"}>} OrderDate)

Please check your date formats