Set analysis with Date

[Husky_Bab12]

Hi ,

I need to sum quantity based on input dates with below expression. Please, some one help let me know where I'm going wrong

=sum({<$(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}>} Quantity)

The shift date is in the format, 2022-Sep-02. 

I'm receiving 0 no matter the input I give on vStart and vEnd.

Where , vStart= 0 and vEnd = 0. 

[Lisa_P]

Try just using the field [Shift Date] instead of $(='[Shift Date])

[Husky_Bab12]

I tried the below its still giving me 0.

=sum({<[Shift Date]={">=$(vStart)<=$(vEnd)"}>} Quantity)

[Lisa_P]

What does it show in the expression editor at the bottom of the screen ? This should give you a clue to the issue.

[Husky_Bab12]

It says expression okay. I think it is because of the shift date format. what do you say?

[Lisa_P]

Is the Shift Date detected as a date in the data or a string ? What format are your variables showing ?

[Husky_Bab12]

it is loaded in date format.

[Vegar]

Try this

=sum({<[Shift Date]={">='$(vStart)'<='$(vEnd)'"}>} Quantity)