07-18-2023 02:31 PM
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?
Solved! Go to Solution.
07-19-2023 05:40 PM
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.
07-19-2023 05:40 PM
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.