Date Range

[#1]

Hi All,

How i get values between one particular date to another,

Ex,

=sum({<SalesNumDate={">=$('01-05-2010')<=$('01-05-2016' )"}>}BILLSTONECARAT)

both date this (dd-mm-yyyy) format only but not able to get values kindly let me know how to get values bw two different dates which is hard-coded...

Thanks in advance...

[Gysbert_Wassenaar]

You could try this:
=sum({<SalesNumDate={"=SalesNumDate>=MakeDate(2010,5) and SalesNumDate<=MakeDate(2016,5)"}>}BILLSTONECARAT)

[Anonymous]

Hi

if you would like work with dates only

=sum({$<SalesNumDate={'>=01-05-2010<=01-05-2016' }>} BILLSTONECARAT)

if you would like work dates with variables

Sum({$<SalesNumDate={'>=$(=Date(vFromDate, 'DD-MM-YYYY'))<=$(=Date(vToDate, 'DD-MM-YYYY'))'}>} BILLSTONECARAT)

[#4]

Hi GD,

Thanks it worked well...