Expression is giving no result

[sakshikaul]

here in above image the datatype used in database is user defined ie Money. Now when I am writing an expression its not giving correct result. Following is the expression :-

=sum({< Sold_Date = {">=$(From)<=$(To)"} >}[inv value] )

can be seen in the below image

But if I am using expression as sum([inv value] its giving me correct answer

and for conversion I have used following in the script.

Date(vouch_date, 'YYYY-MM-DD') as Sold_Date,

Please help

[tresesco]

Try:

=sum({< Sold_Date = {">=$(=Date(From, 'YYYY-MM-DD'))<=$(=Date(To, 'YYYY-MM-DD'))"} >}[inv value] )

[arvind1494]

sum({< Sold_Date = {">=$(=date(From))<=$(=date(To))"} >}[inv value] )

[sakshikaul]

bOTH OF THEM ARE NOT GIVING ANY RESULT

[arvind1494]

If possible then Please send your data

[MindaugasBacius]

Maybe:

=sum({< Sold_Date = {">=$(=Date($(=From), 'YYYY-MM-DD'))<=$(=Date($(=To), 'YYYY-MM-DD'))"} >}[inv value] )

[lorenzoconforti]

When you hover the mouse over the Sold_Date field in the table view, does it show as $date tag?

[jyothish8807]

May be this:

=sum({< Sold_Date = {">=$(=Date($(From), 'YYYY-MM-DD'))<=$(=Date($(To), 'YYYY-MM-DD'))"} >}[inv value] )

Just check the out put of both the variables in a text box to be sure:

1. Date($(From), 'YYYY-MM-DD')

2. Date($(To), 'YYYY-MM-DD')

Br,

KC

[juraj_misina]

You need to format your Sold_Date field as a date in script:

Date#(Sold_Date, 'YYYY-MM-DD')     ad SoldDate

From the screenshot it seems that it is a text field, which makes it impossible to do > and < comparisons.

Hope this helps.

Juraj

[sakshikaul]

Hi

I am getting following result