The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

CarlosA's avatar
CarlosA
New Contributor
21 days ago

Excel Add-in - Quick view - Style for dates

Hi everyone !

We'd like to recover data in a date format using Quick Views.

First step is to setup a CubeView that can recover this data. To do so, the CubeView setup is done in "Cell Type = Date " in the Data tab of the given line on the CubeView definition. 

Setup of cell type in CubeView

Then data can be correctly input in the CubeView:

Possible selection when data is type "Date"

.

This particular date is saved as 639,160,344,000,000,000 (numeric value) in the data base.

Next step it to recover this data using the quickview, but I can't get the correct style. It seems that the data in Onestream is different to that of the Excel date style (Excel starts from 1/1/1900 as day 1).

Set up of the style in a given quick view

Does anyone know how to properly set up the style to recover dates using a QuickView?

Thank you

Carlos

 

 

No RepliesBe the first to reply