How to extract month from string?

[leewe01 (Lee)]

Hi,

Can anyone guide me on how to extract the months from the following dates in data tables?

Dates:
2013-03-18
2015-05-07
2016-06-22

Thanks in advance!

[SagarSB]

@leewe01
you can use trim function to do this.

[leewe01 (Lee)]

Hi @SagarSB,

Would you mind to elaborate further about it?

[Bharat (Bharat Kumar)]

Try this

[leewe01 (Lee)]

Hi @Bharat,

Thanks for the suggestion.

I’ve just tried. But it pops out an error as follows. Please advice.

“Assign: String was not recognized as a valid DateTime.”

[Manjuts90]

@leewe01 (Now.Month).ToString it gives month for present date

[leewe01 (Lee)]

Hi @Manjuts90,

Thanks for the feedback!

However, I would need to extract the months from the series of dates shown above. Please advice.

[Manjuts90]

@Manjuts90

Now

Check the below workflow

@leewe01 instead of Now give column number and checkdt.xaml (8.0 KB)

[leewe01 (Lee)]

Thanks!

But it pops out an error, Option Strict On disallows late binding.

[Manjuts90]

@leewe01m what will be the type of value u get from json whether it is in string format?

[leewe01 (Lee)]

The values I got from Json is Jobject.

[Manjuts90]

@leewe01 can u convert that Json object to string type. Then apply that statement.