Framework:FKT TimeDimDatePart

From CoPlanner 11
Jump to navigationJump to search

Function

Available from CoP 10 HF 1.5

FKT_TimeDimDatePart(

Parameter Description
Time interval Y for year, Q for quarter, M for month or D for day are supported
ID of the time dimension COPSYS_ID of the time dimension

This function belongs to server-side functions.

Result

Returns the choosen interval for the element of the time dimension.

Examples

FKT_TimeDimDatePart(Y,2010050304) returns the year -> 2010

FKT_TimeDimDatePart(Q,2010050304) returns the quarter -> 2

FKT_TimeDimDatePart(M,2010050304) returns the month -> 5

FKT_TimeDimDatePart(D,2010050304) returns the day -> 3