Date variable not showing correct value

[maryna_hubska]

HelloI I need to filter different tables by date. I wanth to do this using start and date variables.

I have some problems with this, because I cann't count date difference or even look at year number

[Gabbar]

You are using Date and Date# functions in wrong way, 
Date# is used to define format in which your date is present in Source ,
Date is used to define format you want it as output.

try using 
start_date as  date(today()-20)
end_date  as date(today())
date_diff as year($(=end_date)) or year(Today()) as your end_date is same as today()

[maryna_hubska]

Unfortunately, this doesn't work

[Gabbar]

Dont know why is this happening
Meanwhile try these in yours:

If i get to know why that is happening, will get back to you in this same thread.

[vinieme12 · Accepted solution]

Date() is a Formatting Function

Date#() is an Interpretation Function

Check the DateFormat variable set in the "Data Load Editor"

All field recognized as date fields will have the below format as defined in variable DateFormat 

Change Variable Definition to below

start_date

= Date(Today()-20)    // with the leading equal sign

end_date

= Date(Today())  // with the leading equal sign

date_diff

=year($(end_date))