Get Month Value from Text

(0) Share

Report

Posted on by PhilippMer

Hello,

currently having an issue, where I have a Text Column Month ("January";"February" etc).

I would like to add another Column using for the DateID with the corresponding Values "January" -> 1 and so on .
This Column will have for example 20220101 as an Value.

Is there a function in which i can retrieve the Month value?

Thanks in advance.

Categories:

General Questions

All responses (1)

Answers (0)

WarrenBelz 147,815 Most Valuable Professional on at

Like (0)

Report
Re: Get Month Value from Text

Hi @PhilippMer ,

This should do it

Text( DateValue( Mid( YourText, 3, 2 ) & "-" & Right( YourText, 2 ) & "-" & Left( YourText, 2 ) ), "mmmm" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps