count number of records

[narender123]

Hi All,

I want to calculate no of Entry of 7 day back from today.

condition:

prerelease_date= date(Today)-7.

See my sample attached qvw file.Please give me solution??

Thanks.

Narender

[#2 · Accepted solution]

The date format in your app is:

DateFormat='M/D/YYYY';

But in inline load you loading data like:

30/06/2013

which is 'DD/MM/YYYY'.

[narender123]

Hi,

Could you sort out my sample qvw.

I know the difference .But i dont know the expression what i have to use ,as i had used much expression but still didnt get solution.

Thanks for reply.

[#4]

I updated my post above and corrected error in your expression too.

[#5]

Also, i think you need sum, not count.

[narender123]

Thanks.

There is a mostake betwwn bracks')'.

Narender