Urgent help assistance

Hi Friends,

I am struck with a difficult situation.

I have Module 1 and this is the Data Hub and the Date is stored in Text Format.

Every quarter I need to pull the data and make it look like Module 2.

Now my problem is as the Date is in Text Format, I was trying to find the current year.

By converting Text to Number and then Rank.

But it didn't work.

Any help will be highly appreciated.

This works only when we can refer the Time Period.

But here, date is stored as Text.

Accepted answers

Follow these steps to convert Text formatted date to Real DATE

refer my previous post to get the current year or current quarter

Thanks,

Thanks @prabhu for yoyr generous kind help.

This is a new solution and is very useful.

But my requirement is different. Let me brief you on this.

What I am trying is to create a Lookup function of the Sys Period. But it shows as a different dimension.

If I would just pull up only te values of the current period, Jun 20. Then that will be really helpful.

you can just PERIOD() the date to get the time period

but that won't help you lookup in your sys module. What is this dimension Year (A) and Year (B) ?

I am sorry brother. i am not 100 % clear.

I assume that in

abc main mod - current month line item - you except "june 20".

Which should be formula driven based on abc sys mod 1 - Year (B) line item.

if this is that?

Then formula for current month line item is : abc sys mod 1.Year (B)

Can you please elaborate more by referring respective line item.

Thanks,

Thanks Bro for the reply.

I was able to resolve it.

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…