Forum Discussion

Jig_S's avatar
Jig_S
Frequent Visitor
10 years ago
Solved

Strange behavior using R script in Query and Date Values

Hello,   I ran into a strange behavior when trying to use the newly introduced R script support in Query mode and date values.    We performed a cumulative sum on some values related to time-seri...
General Comment
Show and Tell
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    Jig_S

     

    I’ve also reproduced this problem locally and reported it internally. I’ll update here if there is some feedback.

    For now, you can use the workaround you’ve found.

     

    Best Regards,

    Herbert

qshngv's avatar
qshngv
Frequent Visitor
9 years ago

I'm having the same issue. Is there any updates on this bug?

 

I have also tried jb1t's script but still have all dates exported as Microsoft.OLEDB.Date.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

qshngv

 

This is a known limitation that is not going to be fixed any time soon. The workaround is to convert the date time to a primitive type (e.g. string) before sending it to into R and then convert it back in resulting table.

 

Best Regards,

Herbert