Getting start and end date from file name

[lumjingbki]

Hi can someone help me how to get the Start and End date For eg - My file name is "Records - May'23" I want to use the "May'23" and get the Start date as 5-1-2023 and end date as 05-31-2023. First day of may and last day of may based on the year 23.

[Hamder83]

This is one idea:

[lumjingbki]

@Hamder83 thank you it worked