Forum Discussion

satishr's avatar
satishr
Helper III
8 years ago
Solved

How to retrieve and convert dates in custom visual?

Hi, I'm developing a custom visual where a bar chart should display values for last 15 days. I have date column and value column. I'm having a hard time retrieving the date values. Please help me.


I'm using table rows data view mapping. I need to retrieve these dates, convert them to a proper format, sort them and filter for latest 15 days.

 

I tried getting them as string as got text like this: Mon 1 Jan 2018 00:00:00 GMT +5.30 (Indian Standard Time)

Need Help

3 Replies

    • satishr's avatar
      satishr
      Helper III
      8 years ago

      Implemented it. But it shows month number incorrectly.

       

      var dateFormatter = ValueFormatter.create({format: "dd/mm/yyyy"});
      var dateDisplay = minDateFormatter.format(myDate);

      The result is 02/53/2018 instead of 02/02/2018. Why?
      • satishr's avatar
        satishr
        Helper III
        8 years ago

        Solved the format problem. It should be "dd/MM/yyyy" instead of "dd/mm/yyyy". Small m represents minutes and capital M represents months. Thanks.