Urgent help assistance
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.