Skip to main content
Newcomer
Jun 16, 2022 2:28 PM UTC

Cell Type Date

In a cube view, the row and/or column sets can be set to Cell Type “Combo Box” or "Date" Time, if Date is chosen  a cool calendar and a time display will allow users to select a specific date and time in a data cell, however , the display format is not correct, cell formatting does not work  , this this bcs I am using the annotation view? Date selection OS.jpg

3 replies

Veteran
Jun 16, 2022 4:03 PM UTC

Hello,

What happens when you try number format MM/dd/yyyy with view "Periodic" and view "annotation"?

lore_hepoAuthor
Newcomer
Jun 16, 2022 4:19 PM UTC

Hi Bharti

well.. If the period is closed the cells get locked., if period is Open, the combo box is not available anymore and the calendar format MM/dd/yyyy still does not work

Member
Jul 27, 2023 5:51 PM UTC

I'm sure you figured this out by now but for future readers I'll respond. I had this exact same issue today. I think it's because the Cell Type of Date doesn't like the view of Annotation. I needed the rest of the cube view to still be Annotation so in the member filter for that date row I put a view filter of Periodic on my account and it solved the problem (e.g A#Account:V#Periodic).