Variable

[smilingjohn]

Hi All,

I have a text boject and within its layout i have a condition which is

Max({Dashboard} Date_MonthNumber) <= Max_Lead_YearMonth

and i checked the variable ( Max_Lead_YearMonth) which is further defined as below

=Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)  

it works fine till janaury 2017 but when i slecet Feb 2017 the text object dissapears

Can someone please suggest if i need to make some changes to the variable ?

it should not dissappear if i select any month . can change the variable like below ?

=Year(max({1} MAX_Lead_Date)) * 100 +Num(Month(max({1} MAX_Lead_Date)))

Thanks in advance

[sunny_talwar]

What exactly are you trying to do here? Would you be able to share a sample? what are the values for Date_MonthNumber and its format and values for MAX_Lead_Date and its format?

[ramasaisaksoft]

Hi John,

Can you elaborate properly?

we didn't understand your issue properly.

[smilingjohn]

Hi Sunny ,

My requirement is it whould even appear for current month ..  and below is the format of the date

[Anil_Babu_Samineni]

Confused, Fully not understand your intend to show

=Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)

Assume You have Dates like 01-01-2016 To 26-02-2017

From here When you use Year here Values come up like 2016 & 2017. This case, For which year you calculating with 100 in Text object. And Month() function returns only Name. I am not sure i understand here due to string and Number are involved on your Expression

[sasiparupudi1]

change the variable

from =Year(MAX_Lead_Date) * 100 + Month(MAX_Lead_Date)  

Date(MAX_Lead_Date,'YYYYMM')

hth

Sas