Dates in Set Analysis

[cgT]

Hi everyone,

I'm trying to use the following expression to return data for a select range of dates:

SUM({<TransactionDate={">=$(=(Max(TransactionDate)-6))<=$(=(Max(TransactionDate)))"}>} SoldSeats)

However, the first transaction date in the range returns as a number in the expression checker below. The value returns as blank also.

Can you help?

Many thanks,

[MayilVahanan · Accepted solution]

Hi

Try like below

SUM({<TransactionDate={">=$(=Date(Max(TransactionDate)-6))<=$(=Date(Max(TransactionDate)))"}>} SoldSeats)