User Profile
Russ_Rimmerman
Joined 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")9.2KViews0likes1Comment
Recent Blog Articles
Use Azure Logic Apps to Notify of Pending AAD Application Client Secrets and Certificate Expirations
Are you challenged with keeping up with all your Azure Active Directory Enterprise Application client secrets and certificates and their associated expiration dates? I sometimes work with customer...111KViews17likes211CommentsUse Power Automate to Notify of Upcoming Azure AD App Client Secrets and Certificate Expirations
Are you challenged with keeping up with all your Azure Active Directory Enterprise Application client secrets and certificates and their associated expiration dates? I sometimes work with customer...139KViews18likes158CommentsUse Power Automate to Extend Microsoft Endpoint Configuration Manager Application Approvals
The native application approval functionality within Microsoft Endpoint Configuration Manager originally only allowed defined admins to approve application requests from the Application Catalog and S...9.6KViews0likes5Comments