making dates

[Anonymous]

hi,

In my Master Calendar I have

  Year(TempDate) As Year

This displays as :-

but when I create a variable for Current Year it displays like this?:-

why does vYear_Current not show as a year?

[avinashelite]

what is the expression your using for defining for the vYear_Current ??

[susovan]

Try this,

=Date(Your Variable,'YYYY')

[Anonymous]

LET vYear_Current = Year(Today());

[Anil_Babu_Samineni]

Laura, The reason is that LET expression. Try to take text object and then try

=$(vYear_Current)

OR

='$(vYear_Current)'

OR in script

Load TempDate, Year(TempDate) as vYear_Current Inline [

TempDate

01-01-2000];

[florentina_doga]

use year(vYear_Current)

[Anonymous]

I tried all three with no luck

[Anil_Babu_Samineni]

Hahaha, Would you share the application. For me it's working good.

[qlikview979]

Hi Try this May be

LET vYear_Current = right(Year(Today()),4)

[Anonymous]

the reason for me wanting to use current year is so that when it comes to month end,  I can revert back to last month for month End Reports.  i.e. this is a data sample .  I simply count all leads for the Week;Month;Year.  I need the CurrentMonth Variable for year to be '2015'