Split Date

zezo2021

Member
Local time
Today, 13:49
Joined
Mar 25, 2021
Messages
400
Hello friends
I want to split this date string in to vale start date and end date

From 1/1/2021 To 1/31/2021

Start Date
1/1/2021
end Date
1/31/2021
 
String manipulation functions. x represents your field or string.

StartDate = Mid(Left(x, InStr(x, "To")-2), 5)

EndDate = Mid(x, InStr(x, "To") + 3)
 
Same as the virtually identical question you asked here
 

Users who are viewing this thread

Back
Top Bottom