Date variable in a expression

[massimo6919]

I have this expression with a costant limit :

SUM(if(data<= '15/01/2014' ,SALDO,0))

if i want to insert a date store in a variable genn_data i wrote

sum(  {$<data<=$(genn_data)>} SALDO)

but don't return the same value. What is wrong ?

[SunilChauhan]

sum(${<data={"<=$(=Date(genn_data,'DD/MM/YYYY'))"}>}SALDO)

[MK_QSL]

SUM({$<data = {'<=$(genn_data)'}>}SALDO)

[alexandros17]

sum(  {$<data={'<=$(genn_data)'}>} SALDO)

but you must pay attention to data format

[PrashantSangle]

Hi,

Try this,

sum({$<data={"<=$(genn_data)"}>} SALDO)

Regards,

[ThornOfCrowns]

What do you get back?

You are probably missing some quotes around your expression i.e. "<=$(genn_data)"

[massimo6919]

when i use costant value the return is     -120953,3

with the alternative give me i obtain         -134040,26

[PrashantSangle]

Hi,

Then First Convert into date Format like,

sum({$<data={"<=$(=Date(genn_data,'DD-MM-YYYY'))"}>} SALDO)

Regards,

[#9]

Hi,

try like this

Sum(data={"<=$(genn_data)"}>} SALDO)

Note: Your variable giving DD/MM/YYYY format and your field data should also be in the same format

[#10]

Massimo,

When doing such date comparisons, I would recommend you to store an integer into your variable with the num function:  num(theDateYouWant) or date#()

The comparison will be easier (no date format to write) and certainly safer.

Fabrice