Today date not giving properly

[saivina2920]

I'm just giving 

=Date(Today()) ==> It's showing 2000

How and Why....?

[sunny_talwar]

Where are you using it?

[saivina2920]

I declared one variable and that variable i used in my textbox.
vFinalCountDate=Date(Today(),'DD-MM-YYYY')  // Variable
In Textbox, i am simply calling that variable.
=$(vFinalCountDate)

[sunny_talwar]

May be just try this

vFinalCountDate

[saivina2920]

no..it's showing string value. not in date.

pls. find attached screenshot.

[saivina2920]

i given
= vFinalCountDate
It's working now....
Thanks..buddy

[sunny_talwar]

Add an equal before the variable name

=vFinalCountDate

[sunny_talwar]

Awesome!!

[saivina2920]

Thanks.
For the same question, with little bit different condition i'm using.
past two days i'm trying. but, nothing will work.
below is my expression.
=Count({<NewDate = {"$(='>=' & vCalDate & '<=' & vToday) & '+' & vFinalCountDate"}>}NewDate)
I am passing some number (i.e. Days) from list box and assign those value to variable.
using that variable (days), i want to add with two different dates.
the count values will not be changing even if i change the value from listbox.
I have attached Qlikview file for reference with screenshot.
pls. let me know if you need any more help.

[sunny_talwar · Accepted solution]

Check the attached