Forum Discussion

pcolas's avatar
pcolas
Frequent Visitor
6 years ago

Decimal to date

Hi community,   I have a problem which is driving me crazy.   I have some data coming from SAP, in which one of the columns is a date in this format: 16/08/2015 4:00:00 AM. However, when I see th...
Need Help
pcolas's avatar
pcolas
Frequent Visitor
6 years ago

Hi nickyvv 

 

Thank you for your reply.

 

This is just to show the desireable result, but this is not the actual outcome. Do you know what I mean or should I try to explain this in a different way?

 

 

 

nickyvv's avatar
nickyvv
Most Valuable Professional
6 years ago
pcolas, please do explain further what your problem is.
  • pcolas's avatar
    pcolas
    Frequent Visitor
    6 years ago

    Hi nickyvv 

     

    My data looks like this:

     

    I want to convert column transaction start to date and then make this table as pivot, so that Event description is on the headers.