Unanswered

Return the Month name from date.

(0) Share

Report

Posted on by ComputerHabit2

Is it possible to return the name of the month from a date?

I'm pulling the month from a timestamp and using it for creating a path to save files. I'd like to use the name of the month instead of the number.

I'm pulling the month with the formatDateTime function.

formatDateTime(triggerBody()?['receivedDateTime'],'MM')

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@ComputerHabit2
Did you try?
formatDateTime(triggerBody()?['receivedDateTime'],'Month')

Was this reply helpful? Yes No
ComputerHabit2 on at

Like (0)

Report

That didn't work at all.

Came back with a value of "8onP9" for this month.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,323 Super User 2025 Season 2 on at

Like (9)

Report

@ComputerHabit2 use 4 Ms. For example if I want the month from today's date I'd use

formatDateTime(utcNow(),'MMMM') which gives the result August

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
ComputerHabit2 on at

Like (0)

Report

Awesome.

I had a hard time finding details on this. Would you happen to have a link to where this information can be found?

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (3)

Report

Not off the top of my head, but it follows the same pattern as Excel, so MM=08, MMM=Aug, MMMM=August.

Rob
Los Gallardos

Was this reply helpful? Yes No
ComputerHabit2 on at

Like (0)

Report

Helpful.

When in doubt look at Excel functions for inspiration.

Thanks again.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

There's nothing better when you're forgetting something that you know that you should know and finding it almost instantly marked as the right answer in the Power User forum. Thanks @RobElliott - you rock!

Was this reply helpful? Yes No
MM-05080756-0 431 on at

Like (0)

Report

Works perfect - but is there a way to return the value in a specific language (not English), or convert it? Of course I could run a replace, but if there was a more effortless way, I'd like that.

Was this reply helpful? Yes No