Expression issue with max and date

[jagjivvt]

Hi,

if i use =max(Date)-7 in the label it works, but when i use the same in set analysis no values are being shown.

count($<{Date={"$(=max(Date)-7)"}>} Distinct Names)

result should be the number of names for max Date.

help please

thanks

[marcus_sommer]

You need probably a date-formating like:

count($<{Date={"$(=date(max(Date)-7, 'YourDateFormat')"}>} Distinct Names)

- Marcus

[sunny_talwar]

Try this:

Count($<{Date={"$(=Date(Max(Date)-7, 'YourDateFieldFormatHere'))"}>} Distinct Names)

[swuehl · Accepted solution]

Try to format according your Date field format:

count($<{Date={"$(=Date(max(Date)-7))"}>} Distinct Names)

[#5]

Vijay, Max function return the number value for date and you need to convert into your date format.

count($<{Date={"$(=date(max(Date)-7, 'YourDateFormat')"}>} [Distinct Names])

[sunny_talwar]

Your Set Analysis brackets are also not in correct places. Try this:

Count({$<Date={"$(=Date(Max(Date)-7, 'YourDateFieldFormatHere'))"}>} Distinct Names)