Jan 05 2022 11:29 AM - edited Jan 05 2022 11:42 AM
Hi all,
I have a text column in a sharepoint list that has dates in it in this format:
Jan 30, 2022 to Feb 02, 2022
I want to make two new date type columns, one that shows the Jan 30, 2022, and another that shows the Feb 02, 2022. I've tried all kinds of combinations with LEFT, MID, DATE, etc and my new calculated Date column only keeps displaying a "1". Any tips?
To get the first date, I've already tried =TEXT(DATE(LEFT(StartDate,3),MID(StartDate,5,2),MID(StartDate,9,4)),"MMM DD YYYY")
Feb 17 2023 12:04 PM
Hello @Russ Rimmerman
have you found a solution?
Have you tried this? https://learn.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=offi...
Best, Dave