User Profile
Russ_Rimmerman
MicrosoftJoined 7 years ago
User Widgets
Recent Discussions
Convert text column to date column using calculated columns
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")8.6KViews0likes1Comment
Groups
Recent Blog Articles
Re: Use Azure Logic Apps to Notify of Pending AAD Application Client Secrets and Certificate Expirat
JStevens5591ahh I see the challenge now - I believe you can only sort by passwordCredentials and keyCredentials but not the endDateTime under them. So probably not going to be as easy as I original...Re: Use Power Automate to Notify of Upcoming Azure AD App Client Secrets and Certificate Expirations
baldeepgillahh I don't think you'll be able to use the html variable for this as it would be getting appended to on each loop. You'll need to break out the info from the current loop iteration and ...