3 Replies Latest reply: Oct 5, 2017 4:21 AM by Anand Singh RSS

    How to get date in expression label

    Anand Singh



      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.