Set Analysis Variables

[#1]

Hello i am struggling with an expression.I have two variables below.

vWeekStartCY = date(date(WeekEnd(MakeWeekDate(year(today()),num(right([Year Week],2),00)-1)))+1)

vWeekEndCY        = date(WeekEnd(MakeWeekDate(year(today()),right([Year Week],2))))

Final Statement

=count({<cus_StartDatum = {">=$(vWeekStartCY)<= $(vWeekEndCY"},
bu3_Market=>} distinct TP_ID)

However the result is 0.

this should not be the case , a helpy hint with my set analysis is much appreicated.

Best

/Brad

[MK_QSL]

Try

=count({<cus_StartDatum = {">=$(=vWeekStartCY)<= $(=vWeekEndCY"},
bu3_Market=>} distinct TP_ID)

[#3]

still not working but thank you for replying

[MK_QSL]

Create two text boxes and use below expressions and let us know the result you are getting...

1)

=$(vWeekStartCY)

2)

=$(vWeekEndCY)

Also provide format of cus_StartDatum

[tresB]

Check how the values are coming in variables, are they of similar formats to the dates in field cus_StartDatum ?

[mightyqlikers]

hi

what you want to get in the two variables .

vWeekStartCY

vWeekEndCY       

try to display those values in textboxes then try in set analysis

Regards

$@M.

[#7]

Yes they are in the correct format  all of them.

YYYY-MM-DD