Showing posts with label Concatenation. Show all posts
Showing posts with label Concatenation. Show all posts

Wednesday, October 2, 2024

Contatenate text to Date to Sort

Convert 01.01.2024  to 01/01/2024 to count as date in Excel.


 =DATE(RIGHT(A2,4),MID(A2,FIND(".",A2,1)+1,FIND(".",A2,FIND(".",A2,1)+1)-FIND(".",A2,1)-1),MID(A2,1,FIND(".",A2,1)))

Resetting the DirectAdmin Password via SSH:

  Resetting the Password via SSH: Access the server as root:   Use an SSH program like PuTTY to connect to your server as the root user.   R...