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

[jagan]

Hi,

Clear all your selections.

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

If not working then attach some sample file with data.

Regards,

Jagan.

[#3]

Thanks...

It's not working... i m going to attach an sample file.. but how is working  cause i look quikly and i see only the possibiliies  to insert an picture, video ... is there any others way, i m gonna to prepare the sample file what is the data size max?

thanks

[anbu1984]

Click "Use advanced editor" while replying and click attach to attach qvw. Max size is 300MB

[#5]

here, there is an small data appli size without dimension....

Thnaks

[tresesco · Accepted solution]

Put '=' sign while defining variable.

[#7]

yes thank Tresesco... it s better...

But it s an little strange the  value of my two variable give  strange results (in objet text)  :

$(vYDMIN)=  0.000048.....  in format date 30/12/1899

$(vYDMAX)=  0.000098.... in format date 30/12/1899

but my expression gives the good results....

Thanks a lot