Text Functions

Options
mthakker
mthakker Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Anaplan Community

There should be a function to convert Date to Text -- call it TEXTDATE(x)

Comments

  • tbeck
    tbeck Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    That would be great if there was a TEXTDATE(x) function. 

     

    There is a way around it that includes concatenating text fields based on the DAY(), MONTH(), and YEAR() of a particular date.

     

    I will demonstrate by using the day function, only to show an array of dates with multiple output options: 

    tbeck_0-1657821035911.png

     

    First, I create line items for the Text output for the Day, Month, and Year, I have separated them for display purposes but these line items can be nested into one if memory is a concern. 

     

    Next, I created multiple outputs in case there are different countries or business criteria across the company.

     

    Below if the grid view for the outputs of the different date formats: 

     

    tbeck_1-1657821327778.png

     

     

     

     

     

     

     

     

     

  • mthakker
    mthakker Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Thank you for this solution. This is helpful as there is no other option but creates unnecessary calculations and increases clutter.

    Vice versa the formula should work in the opposite way too.  

Categories