Read month only from date format

[DTECH (Frank DTech)]

Greeting,

As mentioned from title above, I try to make the bot read month only from the date. For example: 01/03/2021 to 3 only. From my previous developer, he try using assign activities, but the output got logical error.

The dateformat read as dd/mm/yy

System.Text.RegularExpressions.Regex.Replace(dateoutput ,“\d”, “”)

The input was “31/01/2021”

The output becomes “//”

Appreciate for the solution.

[jack.chan]

@DTECH

31/01/2021”

this will give you 3 (as integer )
DateTime.parseExact("01/03/2021", "dd/MM/yyyy", nothing).Month

[DTECH (Frank DTech)]

It was in string format since I capture the date from excel and assign it into variable. So im getting error conversion.

[jack.chan]

whats the error?

if bankReconcillation is string, you need to add .toString after Month

[DTECH (Frank DTech)]

Thanks, it works ! Appreciated