Filter between two Date

[danosoft]

Hi i have this set analisys in a my straight table:

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

the value  of my variable $(vFineMonthContrAlt) is the end of the month i choose (ex: 31/03/2018)

the value  of my variable $(vFineMonthContrAltSCAD) is the end of the next month i choose (ex: 30/04/2018)

so with this set analisys i thought i can take record in the range :

DATA_OUT > 31/03/2018     and    DATA_OUT <= 30/04/2018

but this is not......

i look it only consider the second filter DATA_OUT <= 30/04/2018 and not the first..... why?

thanks

[olivierrobin]

hello

if you want to select a range, you should code

Date={'>MinValue<MaxValue'}

[danosoft]

so in my case, how can i change my set analisys?

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

[olivierrobin]

try something like that

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"}<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

[danosoft]

Sorry but it set wrong sintax your expression, my expression is that, how can i change it?

Sum({<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>} CONSUMO_TOT_ANNUO)

[sunny_talwar · Accepted solution]

May be try this

Sum({<DATA_OUT = {">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>} CONSUMO_TOT_ANNUO)

[olivierrobin]

sorry,

maybe like this

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}