Date difficulty

[Robert E Lee]

Hi all

I have extracted the date from a file name using the following code

Date1 = Right(Left(Name, Len(Name) - 4), 9)

I now need to use this text date to create a date in DD/MM/YYYY format so using Date1 i tried this

Date2 = Left(Date1, 3) & "/" & Right(Date1, 6)

which failed

doing the same thing in two stages and then concatenating the results did produce the desired result

Month = Left(Date1, 3)
Year = Right(Date1, 6)
Date2 = Month & "/" & Year

I would love to know why the second is acceptable but not the first

Also, if I may add a second question, when the "Date2" is entered the date shows as 01/09/2109, is there any way I can make it 30/09/2019 and to have the last day of succeding months

Many thanks

Rob

 

[Robert E Lee]

Neat, thanks

Rob