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
Solved! Go to Solution.
You can do this in a simple formula:
substring(tostring([Text]),2,2)
Hope this helps,
M.
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.