Returning last 7 days of data

[Giselle100]

Hi there

I have the below expression

Count({<[Status]={8} >}distinct [Order No] )

How do I amend it to only return the data for the last 7 days?

[sunny_talwar]

May be something like this

Count({<[Status] = {8}, DateField = {"$(='>=' & Date(Today() - 7, 'DateFieldFormatHere'))"}>} DISTINCT [Order No])

[Giselle100]

Its returning a zero value

[sunny_talwar]

What was the exact expression you used? Did you replace DateFieldFormatHere with the format of your date field?

[Giselle100]

Count({<[Status] = {8}, [Outscan Date] = {"$(='>=' & Date(Today() - 7, 'YYYY/MM/DD'))"}>} DISTINCT [Order No])

[sunny_talwar]

The expression looks good... are you looking for last 7 days from today or last 7 days from the max date in the database?

[Giselle100]

max date

[sunny_talwar]

Then try this

Count({<[Status] = {8}, [Outscan Date] = {"$(='>=' & Date(Max([Outscan Date]) - 7, 'YYYY/MM/DD'))"}>} DISTINCT [Order No])

[Giselle100]

Still returning a zero value

[sunny_talwar]

Would you be able to share a sample to check this out?