2 Replies Latest reply: Jul 3, 2017 4:36 AM by Devarasu R RSS

    How to get date in expression label

    Anand Singh

      Hi,

       

      I have a calendar object in dashboard that i use to select date (in 'M/D/YYYY' format) and pass on the data value to a variable 'vBaseFrom'.

      Now i have a table where i want to show this value as label for an expression. I used following code in Label,

       

      ='Sample% '& Date($(vBaseFrom),'M/D/YYY')

       

      However i am getting following result not matter what i choose,

      Sample% 12/30/1899

       

      I am using this variable for set analysis & it's giving right result. Which means it has got the value & i can see it variable overview window.

       

      Can anyone help please.