AnsweredAssumed Answered

Function Month on a date cube

Question asked by sleger@exoset on Mar 31, 2018
Latest reply on Mar 31, 2018 by tg_jbaetens

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.

Outcomes