Get Month Value from Text

Like (0) Share

Report

Posted on 12 Oct 2022 10:19:45 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 149,147 Most Valuable Professional on 12 Oct 2022 at 21:13:13

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