Between Dates Set analysis

[siddheshmane]

Hi,

I'm working on set analysis which requires between dates

-(sum({<[Posting Date]={"$(= '>=' & $(=DATE(TODAY() - 30)) & '<=' & $(=DATE(TODAY())))"}, [Document Type]={'Invoice'}>}Quantity))

But my output displays as 0.

Can someone help me with this.

Thanks,

Siddhesh Mane

[avinashelite]

Try like this

sum({<[Posting Date]={">=$(=DATE(TODAY() - 30)) <=$(=DATE(TODAY()))"}, [Document Type]={'Invoice'}>}Quantity))

[sunny_talwar · Accepted solution]

Or this where you don't use the second dollar sign expansions for Date(Today()....) part:

-(Sum({<[Posting Date]={"$(= '>=' & Date(Today() - 30) & '<=' & Date(Today()))"}, [Document Type]={'Invoice'}>} Quantity))