count record??

[narender123]

Hi Team,

I want to count prerelease_numbers where prerelease_date= date(today)-7 means prerelease_date=one week back date from today.

prerelease date is in DDMMYYYY format.

Expression:

=count({<Year={$(=Max(Year)),prerelease_date={$(=Date(Today()-1))}>}prerelease_numbers)

I have attached a sample .qvw .if possible then sort out it.

Thanks.

Narender

[narender123]

Hi All,

Thanks for your reply.

I have solved this.

My error is due to using both year and date in same expression.

Actually Year and date not working together in same expression.

Thanks.