String formatting of piped dates

I want to get a dir then select on the LastWriteTime and from that get the
hour formatted with a leading zero if less than 10.

This is what I tried but it failed:

PS > dir | select "{0}" -f {$_.LastWritetime.hour}
Select-Object : Cannot bind parameter 'First'. Cannot convert
"$_.LastWritetime.hour" to "System.Int32".
At line:1 char:23
+ dir | select "{0}" -f <<<< {$_.LastWritetime.hour}
PS >

I'm new to Powershell so any assistance would be appreciated.

Thanks

Altraf

Using calculated property to create the version of LastWriteTime you want:

dir | select Mode, @{name = 'LastWriteTime';
expression = {"{0:mm/dd/yyyy hh:MM tt}" -f ($_.lastWriteTime)}},
Name, Length | format-table -auto

--
Kiron

Try

dir | foreach {$_.LastWritetime.Hour.tostring().padleft(2,"0")}



Shay
http://scriptolog.blogspot.com


PS>> dir | select "{0}" -f {$_.LastWritetime.hour}
PS>>

With calculated property

dir | select name,@{name="Hour";expression={$_.LastWritetime.hour.tostring().padleft(2,"0")}}



Shay
http://scriptolog.blogspot.com


PS>>> dir | select "{0}" -f {$_.LastWritetime.hour}
PS>>>

Sorry first post had a typo:

# Using select-object:

dir | select Mode, @{name = 'LastWriteTime';
expression = {"{0:MM/dd/yyyy hh:mm tt}" -f ($_.lastWriteTime)}},
Name, Length | format-table -auto

# Using formatt-object, its calculated field has an alignment attribute:

dir | format-table Mode, @{label = 'LastWriteTime';
expression = {"{0:MM/dd/yyyy hh:mm tt}" -f ($_.lastWriteTime)}},
@{label = 'Length';
expression = {$_.length}; align = 'Right'}, Name -auto

--
Kiron

Thanks Kiron

After looking at your example I ended up with:

dir | select @{name="LastWriteTime";expression={"{0:hh}" -f $_.lastWriteTime}}

This does what I want, and I've learnt a bit more about Powershell.

Altraf

Hi Shay Levi

Your suggestion also gives the desired result. I now have two ways of
achieving my goal.

Thanks.

Alan

Oh the glory of powershell

Brandon Shell
---------------
Blog: http://www.bsonposh.com/
PSH Scripts Project: www.codeplex.com/psobject

A> Hi Shay Levi
A>
A> Your suggestion also gives the desired result. I now have two ways
A> of achieving my goal.
A>
A> Thanks.
A>
A> Alan
A>

"Altraf" <Altraf@xxxxxx> wrote in message
news:62AC7705-2226-41A2-8A7D-D43BEACB35B5@xxxxxx
Be aware that times after midday will be displayed in 12 hour format with
that, which may not be what you want.


Compare to (24 hour format)

dir | select @{name="LastWriteTime";expression={"{0:HH}" -f
$_.lastWriteTime}}


There's a good discussion here on formatting dates and times in PowerShell,
which may also give you some more ideas

Formatting Dates and Times
http://www.microsoft.com/technet/scr...pstip0831.mspx



--
Jon

To add to the confusion:

dir | foreach-object {"{02}" -f $_.LastWritetime.hour}

"Altraf" wrote: