rData Table: Date Format

[adieball]

Hi

my source has two date fields, properly configured as format dd/MM/yy and in the table it correctly shows up.

When dragging this field into a rData Table, the date shows with an added Time stampt like T00:00:00.0000000 like in the attached picture.

I search everywhere, but haven't found a solution how to avoid this. I want the rDataTable to just show the date.

Any help is highly appreciated

[v-jiascu-msft]

Hi @adieball,

I would suggest you contact the author directly. Please refer to https://deldersveld.github.io/powerbi/support/rdatatable.

Best Regards,

Dale

[TomMartens]

Hey,

I'm not sure but I guess you have use

as.Date(,,,)

inside your r script.

Regards,

Tom

[adieball]

rScript?

I just use that rTable Plugin from the Marketplace and drop the fields in ......

[TomMartens]

Okay, I understand, that's the way this visual display "date" and "datetime" fields.

Maybe you can consider to transform the columns to the datatype text.

You also can consider to report this as an issue here:

https://github.com/deldersveld/rDataTable

Regards,

Tom