Simple: Problem loading data on LOAD

[#1]

Hi guys,
Far as I understand we can't use result as function to filter searching at expression on table chart.
On the expression I have code as follow:

if(([Date("Leave From Date")] - [Date("System Date")]) < 3,[Day("System Date")])

Then how do I use this code above on LOAD database?
If I type in with this code below give me "Error in expression: If takes 2-3 parameters"

if((Date("Leave From Date") - Date("System Date")) < '3') as SystemDate,

Basically, we want to load data from database only showing employee taken day starting leave must 3 days advanced before system date.

"System Date" = From System Time and Date present
"Leave From Date" = Employee submitted leave request starting day/FROM
"Leave To Date" = Employee submitted leave request until day/TO

Much appreciated anyone can help.

Thanks

[#2 · Accepted solution]

The syntax for an IF statement is if(expression, value if true, value if false)... the expression and value if true are required, however the value if false is optional.

To correct line from your load statement, add a value if true like this...

if((Date("Leave From Date") - Date("System Date")) < '3', "System Date") as SystemDate,

[#3]

Fantastic, thanks it solved!