Function Month on a date cube

Unknown

Hi,

 

I need to calculate prepaid expenses.

By writing, I have:
- an "Amount" cube,
- a cube, in date format, "Start date",
- a cube, in date format, "End date".

I just need to retrieve, in a calculated field, the month of the "Start Date" cube.
So, I just tried month (b) and it does not work because it looks like the Date field is like a numeric field.

Unknown

Hi Sébastien,

I believe the MONTH() functionality only works in NEXEL and not directly in your dataview layout.
.

I am not 100% clear about how the dimensions of your cubes look like but I believe I have two potential options for you.

 

1) You can use the MONTH() functionality in NEXEL retrievable from functions:
2) You can use the left() functionality in the dataview to treat your data cube as text:

 

I hope I was useful.

All the best,
Jonathan