Date function - Variable

[Anonymous]

Hello,

I am using the below expression directly in a chart  its working but if I try to create a variable using the same expression its giving the expected result. Could any one help me?

=Date(max(Close_Week_End_Date),'YYYY-MM-DD')

Thank you in advance.

Regards,

Rekha J. V.

[OmarBenSalem]

can u please develop more?

1) what chart u're using this expression in? which dimension?

a screen shot maybe?

2) when u use a variable? how are u using it?

how are u calling it?

screen shot maybe?

[Anonymous]

Hello Omar,

This is how I am using in KPI

Created a variable using same:

Now if I use the variable in KPI it will not show up the date

Nor its showing when I use in Set expression

Regards

Rekha

[OmarBenSalem · Accepted solution]

try to call it as follow :

=$(vCurrentWeekEndDate)

or

='$(vCurrentWeekEndDate)'

[Anil_Babu_Samineni]

How you define in variable?

LET Variable = =Date(max(Close_Week_End_Date),'YYYY-MM-DD');

[Anonymous]

Hello Omar,

='$(vCurrentWeekEndDate)' returns the appropriate  date.

Thank you,

Rekha J. V.

[OmarBenSalem]

Good, but u should have marked my answer as correct

[Anonymous]

Sorry by mistake. Marked your answer as correct. 🙂

Thanks once again.