relational operator not functionig properly

[sakshikaul]

hi

Suppose,when user selects a date in calendar as 1st June 2018(from) till 30th June 2018(to) , here i only want to depict sales for the end date ie 30th june 2018 and all other data against each date should be 0

so in below expression =sign is not functioning

=num(sum({ <Sold_Date = {"< $(To)"} >} Target)  ,'#,##0.0')

[sasikanth]

Try this,

num(sum({ <Sold_Date = { "< $(=Date(To))"} >} Target)  ,'#,##0.0')

[Anil_Babu_Samineni]

As always, You are creating multiple threads for single issue. I suggest you to keep one only. Perhaps this?

=num(sum({ <Sold_Date = {">$(=From)< $(=To)"} >} Target)  ,'#,##0.0')

Or

=num(sum({ <Sold_Date = {">From< To"} >} Target)  ,'#,##0.0')

Or

=num(sum({ <Sold_Date = {">$(From)< $(To)"} >} Target)  ,'#,##0.0')

Finally, you must check how variables storing and Field values Sold_Date ??

[ahmar811]

Please use below expression

=num(sum({ <Sold_Date = {"$(=MonthEnd(Max(DateField)))"} >} Target)  ,'#,##0.0')

or

=num(sum({ <Sold_Date = {"$(=MontheEnd($(To)))"} >} Target)  ,'#,##0.0')

Regards

Ahmar