How to retrieve and convert dates in custom visual?

[satishr]

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)

[v-viig · Accepted solution]

You might use valueFormatter to format date to a proper format.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[satishr]

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]

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.