Forum Discussion

CarlosA's avatar
CarlosA
Visitor
6 hours 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