Forum Discussion

GW's avatar
GW
New Contributor II
2 years ago

Is there a way to copy paste excel values into CV forms for dates?

Hi,

Copy pasting data from excel into CV forms generally work, but the exception seems to be for date values (CV Cell Type - Date). Does anyone have experience with this and know if it's possible?

 

 

Infrastructure
Time
  • Steven's avatar
    Steven
    2 years ago

    Dates in OneStream are stored as binary numbers in the cube.

    The calendar plug in converts the binary value to a readable date.  So if you copy the value from OneStream and paste this into notepad, you will see that it is a binary number.  If you copy the date from excel, you will need to convert it to binary and then paste it into OneStream.

  • Steven's avatar
    Steven
    Contributor II
    2 years ago

    Dates in OneStream are stored as binary numbers in the cube.

    The calendar plug in converts the binary value to a readable date.  So if you copy the value from OneStream and paste this into notepad, you will see that it is a binary number.  If you copy the date from excel, you will need to convert it to binary and then paste it into OneStream.