Problem with days in weekstart and weekend

[fkeuroglian]

Hi, i have a problem that i cant resolve

I have day, month, year that is create based on  the date(day/month/year)

i want to count some particular things using weekstart (date selected) and weekend(date selected)

when the date selected is the field date(28/08/2013) the result is ok 4467

but when i do the selection in parts(first year, then month and then day) the result is 0 in the same date

the problems appears when i select the day.. when i select year and month is ok

i send attach a simple qvw with this case

please let me know if you can help me!

thank you a lot

Fernando

[tresesco · Accepted solution]

You should bypass day, year, month selection using set analysis like:

=count({<Day=,Month=,Year=,SolDateValeReal={">=$(=weekstart(max(makedate(Year,Month,Day)),-1))<=$(=weekend(max(makedate(Year,Month,Day)),-1))"}>} distinct SolNroVale)

[fkeuroglian]

Thank you a lot!

Other Solution

=Count(DISTINCT {1<SolFchValeReal ={"$(='>='&Date(WeekStart(Only(Fecha))-7)&'<='&Date(WeekStart(Only(Fecha))-1))" }>} SolNroVale )