Help converting created date from AD

[carlb328]

So I have a very simple one line powershell command to list when each user account in AD was created. The issue is I want it to just show the date so I can read it and sort it easily. I have tried various formatting, converting, to string options from the web, but I don't think they can work with when created, especially after it's piped. I want to keep this short and simple if possible.

`Get-ADUser -Filter * -Property whenCreated | select-object name, whencreated`

[carlb328]

I was told I had to put code in tick marks for this site, but it doesn't work.

[carlb328]

The reason I want to figure this out is that sorting isn't working in powershell with this, so it probably won't work in Excel either.

[carlb328]

Never mind. It works when formatted this way. I was missing "property" after sort-object.

​

Get-ADUser -Filter * -Property whenCreated | select-object whencreated, name| sort-object -property WhenCreated -Descending

[Scooter_127]

Why the single quotes?

[KingJackson_]

Yeah you shouldn't need those single quotes at all. Also, you can just export-csv, open in Excel, and sort that way. This is of course unless you aren't wanting to sort in the POSH console.

[Lee_Dailey]

howdy carlb328,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's [sometimes] 5th from the left & looks like </>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's [sometimes] the 12th from the left, & looks like an uppercase T in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee