basic set analysis woes

[toddbuss]

This formula shows all records that fall within the latest date in the set:

count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))"}>}[Date Submitted to TC])

This formula should show all records that fall within the 7 days prior to the latest date in the set:

count({$<[Date Submitted to TC]={">=$(=max([Date Submitted to TC]))-7"}>}[Date Submitted to TC])

The first formula works, but the second doesn't.  I've been tinkering for hours trying to get this to work.   Any help would be appreciated.  Thanks.

[sunny_talwar · Accepted solution]

Move -7 within the dollar sign expansion. You might also need Date() function with the date format of Date Submitted to TC

Count({$<[Date Submitted to TC]={">=$(=Date(Max([Date Submitted to TC])-7, 'DateFieldFormatHere'))"}>}[Date Submitted to TC])

[toddbuss]

that fixed it.  Thanks.