CarlosA
6 hours agoVisitor
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 CubeViewThen 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 viewDoes anyone know how to properly set up the style to recover dates using a QuickView?
Thank you
Carlos