Z zezo2021 Member Local time Today, 13:49 Joined Mar 25, 2021 Messages 400 Jan 29, 2023 #1 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
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 AWF VIP Local time Today, 03:49 Joined Mar 9, 2014 Messages 5,838 Jan 29, 2023 #2 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)
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)
C CJ_London Super Moderator Staff member Local time Today, 11:49 Joined Feb 19, 2013 Messages 17,321 Jan 29, 2023 #3 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
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