Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Concatenate & Convert Period and Year to Full Date

edited Jun 27, 2018 11:10PM in Planning 4 comments

Summary

Looking to compare the currently selected Year-Period members with a date-typed Account dimension member.

Content

Is it possible to concatenate and then convert a selected Year-Period intersection into a usable full date string inside of a Dynamic Calc member formula (ASO, Account Dimension)?  For example, we have a need for the below result:

([Years].currentmember, [Period].currentmember, "01") = 20180501 (when May and FY18 are the currently selected member).

I have been working on this question for a while and cannot quite get to a full solution.  I have tried a number of different methods pulled out the current Technical Reference but nothing seems to validate correctly.  I know how to go the opposite direction (converting "20180501" into "May" and "FY18") but can't seem to translate the logic.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!