Posted On November 3, 2021

Convert LastLogon Date From Number to Date Time

kimconnect 0 comments
blog.KimConnect.com >> Codes >> Convert LastLogon Date From Number to Date Time
November 3, 2021November 3, 2021 kimconnectkimconnect 0 Comments

We have a case where our Admins have generated a CSV file with information about user accounts with associated LastLogon date value as a machine numerical value, rather than the human readable date value. A convenient way of expressing that value would be as follows:

1. Create a new column with this formula (tested to work with Excel and Google Spreadsheets):

=IF(G2>0,G2/(8.64*10^11)-109205,"")

2. Format the new column as ‘Date time’ as illustrated below.

Categories:

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

Post Image

Read More

PowerShell: Purge OneDrive

# purgeOneDrive_v0.0.1.ps1function purgeOneDrive{ write-host "Halting OneDrive and explorer processes..." taskkill.exe /F /IM "OneDrive.exe" taskkill.exe /F…
Post Image

Read More

PowerShell: Compressing Files and Folders

# Set variables $compressTarget="C:\Temp\Win2016_Std_Template.ova" $parentFolder=split-path $compressTarget -Parent $grandParentFolder=split-path $parentFolder -Parent $compressedFile=$grandParentFolder+"\compressed.zip" # PowerShell version 5…
Post Image

Read More

PowerShell: Add Quorum to Clusters

# SetClusterQuorum.ps1$clustersAndQuorums=@();$clustersAndQuorums+=[PSCustomObject]@{ClusterName='CLUSTER1';Quorum='\\FILESHERVER007\CLUSTER1$'};$clustersAndQuorums+=[PSCustomObject]@{ClusterName='CLUSTER2';Quorum='\\FILESHERVER007\CLUSTER2$'};function getViableNode{ param($nodes) foreach ($node in $nodes){ $bingo=Test-NetConnection $node -InformationLevel Quiet; if($bingo){return $node} }}…
Other project: DragonCoin.com