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

[GW]

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?

[Steven · Accepted solution]

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.