Powershell's Get-date: How to get Yesterday at 22:00 in a variable?

Question

For a check i need yesterday's date at 10:00pm in a variable.

I get yesterdays Date and current Time with

$a = (get-date).AddDays(-1)

But how do i manipulate the time to 22.00 and leave the variable still as Date-Object?

score 66 · Accepted Answer · edited May 23 '17 at 12:10

66

Use DateTime.Today as opposed to DateTime.Now (which is what Get-Date returns) because Today is just the date with 00:00 as the time, and now is the moment in time down to the millisecond. (from masenkablast)

> [DateTime]::Today.AddDays(-1).AddHours(22)
Thursday, March 11, 2010 10:00:00 PM

edited May 23 '17 at 12:10

Community

1
1

answered Mar 12 '10 at 16:10

James Kolpack

9,331
2
44
59

3

wow I have this long complicated function in one of my scripts that does what this 1 line does. Yay for stupidity on my part. – Buddy Lindsey Jun 02 '10 at 02:20

score 18 · Answer 2 · edited Mar 16 '23 at 02:26

18

I see this topic, but in my case I was looking for a way to improve the format. Using UFormat and adding -1 day

(Get-Date (Get-Date).addDays(-1) -UFormat "%Y%m%d-%H%M")

edited Mar 16 '23 at 02:26

xjcl

12,848
6
67
89

answered Jan 28 '16 at 11:52

javier

191
1
2

score 6 · Answer 3 · edited Nov 15 '11 at 21:01

6

(Get-Date (Get-Date -Format d)).AddHours(-2)

edited Nov 15 '11 at 21:01

John Conde

217,595
99
455
496

answered Nov 15 '11 at 20:57

Kevin

61
1
1

Pluto · Answer 4 · 2018-08-03T00:32:20.720

I saw in at least one other place that people don't realize Date-Time takes in times as well, so I figured I'd share it here since it's really short to do so:

Get-Date # Following the OP's example, let's say it's Friday, March 12, 2010 9:00:00 AM
(Get-Date '22:00').AddDays(-1) # Thursday, March 11, 2010 10:00:00 PM

It's also the shortest way to strip time information and still use other parameters of Get-Date. For instance you can get seconds since 1970 this way (Unix timestamp):

Get-Date '0:00' -u '%s' # 1268352000

Or you can get an ISO 8601 timestamp:

Get-Date '0:00' -f 's' # 2010-03-12T00:00:00

Then again if you reverse the operands, it gives you a little more freedom with formatting with any date object:

'The sortable timestamp: {0:s}Z{1}Vs measly human format: {0:D}' -f (Get-Date '0:00'), "`r`n"
# The sortable timestamp: 2010-03-12T00:00:00Z
# Vs measly human format: Friday, March 12, 2010

However if you wanted to both format a Unix timestamp (via -u aka -UFormat), you'll need to do it separately. Here's an example of that:

'ISO 8601: {0:s}Z{1}Unix: {2}' -f (Get-Date '0:00'), "`r`n", (Get-Date '0:00' -u '%s')
# ISO 8601: 2010-03-12T00:00:00Z
# Unix: 1268352000

Hope this helps!

score 4 · Answer 5 · answered Mar 20 '18 at 15:15

4

Format in other syntax is possible in this way

[DateTime]::Today.AddDays(-1).ToString("yyyyMMdd")

answered Mar 20 '18 at 15:15

Phil Landolt

59
1

THAT'S THE GOOD ONE – silverbackbg Feb 24 '23 at 18:40

score 3 · Answer 6 · edited Oct 01 '20 at 19:36

3

When I was to get yesterday with just the date in the format Year/Month/Day I use:

$Variable = Get-Date((get-date ).AddDays(-1))  -Format "yyyy-MM-dd"

edited Oct 01 '20 at 19:36

fcdt

2,371
5
14
26

answered Oct 01 '20 at 15:50

ClintR

31
1

score 2 · Answer 7 · answered May 31 '18 at 01:31

2

Yet another way to do this:

(Get-Date).AddDays(-1).Date.AddHours(22)

answered May 31 '18 at 01:31

Michael Ward

21
1

1

You might as well do `(Get-Date).Date.AddHours(-2)` – Pluto Oct 24 '19 at 17:36

Mike · Answer 8 · 2021-09-01T00:47:35.740

0

Another possible method but Unix timestamp

 ([int64](Get-Date -UFormat %s) - [int64](New-TimeSpan -Hours 1).TotalSeconds)

edited Sep 01 '21 at 00:47

answered Aug 31 '21 at 19:34

Mike

179
1
1
10

Powershell's Get-date: How to get Yesterday at 22:00 in a variable?

8 Answers8

Linked