String: Extract two middle characters

Hi,

I have the following string: "210617". That is 21= 2021, 06= Jun and 17=day.

Which is the formula to extract "06" ?

I used right with 2 in order to get the day and I used left with 2 in order to get the year, but I can´t find the formula to extract "06"

Regards,

Igancio

Workflow

Accepted answers

You can do this in a simple formula:

substring(tostring([Text]),2,2)

Hope this helps,

You can do this in a simple formula:

substring(tostring([Text]),2,2)

Hope this helps,

@NachoArg , you could use substring('210617',2,2) OR you could use Regex_parse.

Regards,

Shreyansh

Since you are probably running datetime calculations on it - why not just convert it to a date via datetimeparse("20"+tostring([field1]),"%Y%m%d")

then you can use datetimeformat([date],"%m") to get the month and do all those fun datetime calculations...

Thank you both !! 😊

Actually I was trying something like +mid as I use in Excel.

no problem.gif