Split Date (1 Viewer)

[zezo2021]

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

 

[June7]

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)

 

[CJ_London]

Same as the virtually identical question you asked here

Split Value

Hello friends I import data from excel column like this From 7:00:00 AM To 7:59:59 AM I want to split this value to 2 column Start Time 7:00:00 AM End Time 7:59:59 AM

www.access-programmers.co.uk