set analysis with date variables

[#1]

hello everybody,

someone could help me i met an problem with date variable..

I try to put tow date  in an set analysis  but it doesn t work :

• vYDMIN :  Date(Yearstart(max(%date)),'DD/MM/YYYY') 
• vYDMIN  :   Date(Max( %date),'DD/MM/YYYY')  

%date is my key calendar ...

This is  my expression  :

sum({$ <%date={">=$(#vYDMIN)<=$(#=vYDMAX)"} >} [Indic.])

Do you know where is problem , i try a lot of solution but all doesn t work

Thank for your help

[Anonymous]

did you try $(=vYDMIN) instead of $(#vYDMIN) and also with VYDMAX

another point:

why do you format the variable and in the set expression you assign to origin again.

Is there a difference in the format?

how does %date looks like in format?

[marcus_sommer]

Try this:

sum({$ <%date={">=$(vYDMIN)<=$(vYDMAX)"} >} [Indic.])

whereat %date needs to formatted like the variables in 'DD/MM/YYYY'. Less error-prone is by calculations with dates and times is to use numeric values with num(%date).

- Marcus

[Anonymous]

Pierre,

Try this:

sum({$ <%date={">=$(=$(vYDMIN))<=$(=$(vYDMAX))"} >} [Indic.])

Marc.

[#5]

thanks for all answers,

i  ve tried 

sum({$ <%date={">=$(vYDMIN)<=$(vYDMAX)"} >} [Indic.]) this give 0

sum({$ <%date={">=$(=$(vYDMIN))<=$(=$(vYDMAX))"} >} [Indic.])  it doesn't work, this syntax give me no result

All the data are in good format 'DD/MM/YYYY'  and the variable in text object give the rigth date :

$(vYDMIN)=01/01/2014

$(vYDMAX)=16/09/2014

[Anonymous]

try once:

sum({$<%date={'>=$(=vYDMIN)<=$(=vYDMAX)'}>} [Indic]

[#7]

Thank again i ve try but the result is again 0.

Nobody has nay idea about the origin of the problem, i m  desperate ..;)

[Anonymous]

what should be the result?

please define a listbox with %date and select all dates between 1/1/2014 and 16/9/2014

create a textbox with sum([Indic])

what is the result?

[anbu1984]

Can you post sample app.

[tresesco]

Better idea would be - create a qvw with sample data that demonstrates the issue and share. I am sure that you would get faster resolution.