Convert Text date Range to period

Highlighted
Certified Master Anaplanner

Convert Text date Range to period

Hi,

 

I need to covert the text field range to a period number, what should be the formula for that?

 

I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell)

I need an output as period number. 1 for Jan 2019 in one line item and in the second line item 12 for Dec 2019.

 

Thanks for the help 🙂

3 REPLIES 3
Highlighted
Regular Contributor

Re: Convert Text date Range to period

Hi @ShivankurSharma ,

 

You can use Anaplan left/Right/Mid function to get the Year value in separate line item and then use Finditem to get the Year time period. 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LEFT.html

 

If you still need some help, I can post some formula screenshot.

 

Thanks,

Sandeep

Highlighted
Master Anaplanner/Community Boss

Re: Convert Text date Range to period

@ShivankurSharma 

Date transformations are at the top of any modeler's list of things to do. So, great question.

First thing you have to do is convert the text to a date. Then a date to a period.

 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: Convert Text date Range to period

@ShivankurSharma 

 

See if this helps.

 

Misbah_0-1588607092533.png

 

Misbah_1-1588607117811.png