nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date Formats - Month Name/Text from Date

simon_ritchie

Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon

Accepted answers

PrevContributor

Hi Simon,

You can convert a date to the format you described by adding a list with Jan, Feb, etc. and assigning codes 1-12. Then, you can add the line items and formulas shown below to get the month names followed by the year. Let me know if you have any questions!

Thanks,

John

All comments

PrevContributor

simon_ritchie

Hi John,

Thanks for the suggestion. Screenshots are great.
It's a tidy little solution that will suit my purposes very nicely.

Thanks,
Simon

Andrew_Paston

Hi John

I know this is very old post but i was interested in this solution and cant find the formulas you mentioned below? Have they dissapeared?

Cheers

Andrew

MNHHS

John

I can't see any formulas

Chris

pooja.joshi7

Hi John,

Greetings for the day!!

I can't see formulas and screenshots posted by you.

Can you please check once.

Thanks

Pooja

ddevine

This is my solution to output "Feb 21" for example:

Date format: First Date of Period = START()

Output for February is 1/2/2021

Time format (month): Month Period = PERIOD(First Date of Period)

Output is "Feb 21".

Regards,

Declan

Quick Links

Can you help?

Unanswered questions

An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…