{"id":52553,"date":"2009-09-02T03:01:00","date_gmt":"2009-09-02T03:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2009\/09\/02\/hey-scripting-guy-can-windows-powershell-alleviate-my-need-to-type-dates\/"},"modified":"2009-09-02T03:01:00","modified_gmt":"2009-09-02T03:01:00","slug":"hey-scripting-guy-can-windows-powershell-alleviate-my-need-to-type-dates","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-can-windows-powershell-alleviate-my-need-to-type-dates\/","title":{"rendered":"Hey, Scripting Guy! Can Windows PowerShell Alleviate My Need to Type Dates?"},"content":{"rendered":"

\n\n\n\n
Share this post: <\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD>\n<\/A><\/TD><\/TR><\/TBODY><\/TABLE><\/SPAN>\n

\"Hey,<\/P>\n

Hey, Scripting Guy! I hate typing dates. There are several ways of typing dates, and they are all a pain. I do not like having to type the numbers and the whacks, and I do not like having to spell out month names, or attempting to remember if it is month first or day first. I like scripting, but I also like pointing and clicking. Is there something you can do for me? <\/P>\n

— RS
<\/P>\n

\"Hey,<\/SPAN><\/P>\n

Hello RS, <\/P>\n

Microsoft Scripting Guy Ed Wilson here. I am glad you took the time to send an e-mail to scripter@microsoft.com<\/FONT><\/A> because today I am in virtual meetings for 9 hours! I love meetings because I work from home, and I do not get to interact with Microsoftees too often unless I head to the office (a couple hour trek), am on campus in Redmond, speak at a conference such as Tech\u2219<\/SPAN>Ed or TechReady, or attend a virtual meeting. Of course, a Scripting Guy cannot spend all of his time in meetings, but he can always try. <\/P>\n

Interestingly enough, when I was teaching my VBScript class at the Microsoft office in Sao Paulo, Brazil<\/FONT><\/A>, one of my friends told me they were having problems getting people to attend meetings. He had however come up with the solution…Meeting Miles. You get 1 meeting mile for every hour you spend in a meeting (kind of like airline miles). At the end of the month, you can redeem your meeting miles for rewards and for prizes. You could even offer to attend meetings for other people to accrue meeting miles more rapidly. Great idea. I would be able to fly to Hawaii for free twice a year, if we implemented that in my organization. <\/P>\n

I have gotten pretty good at multitasking (but that is the good thing about having a Scripting Wife who reads all of my Hey, Scripting Guy! articles and Craig who edits all my Hey, Scripting Guy! articles), but at times I do get confused and errors of both omission and commission are ultimately mine. <\/P>\n

RS, I took the opportunity to write the Get-DatePickerFunction.ps1 script for you. The DatePicker<\/STRONG> will definitely solve your date issues by alleviating your need for typing dates. The full Get-DatePickerFunction.ps1 script is seen here. <\/P>\n

Get-DatePickerFunction.ps1 <\/STRONG>\n

Function Get-DatePicker
{   <\/SPAN>
 <\/SPAN>[System.Reflection.Assembly]::LoadWithPartialName(“System.windows.forms”) |
 <\/SPAN>Out-Null
 <\/SPAN>
 <\/SPAN>$WinForm = New-Object Windows.Forms.Form   <\/SPAN>
 <\/SPAN>$WinForm.text = “DatePicker Control”   <\/SPAN>
 <\/SPAN>$WinForm.Size = New-Object Drawing.Size(205,55)

 <\/SPAN>$DatePicker = New-Object System.Windows.Forms.DateTimePicker   <\/SPAN>
 <\/SPAN>#$DatePicker.Format = [windows.forms.datetimepickerFormat]::custom
 <\/SPAN>#$DatePicker.CustomFormat = “MM-dd-yyyy”
 <\/SPAN>$WinForm.Controls.Add($DatePicker)   <\/SPAN>
 <\/SPAN>
 <\/SPAN>$WinForm.Add_Shown($WinForm.Activate())  <\/SPAN>
 <\/SPAN>$WinForm.showdialog() | Out-Null  <\/SPAN>
 <\/SPAN>$DatePicker.value
} #end function Get-DatePicker

# *** Entry point to script ***

# Get-EventLog -LogName application -After [datetime](Get-Datepicker) # Windows PowerShell 2.0 call
# wps 1.0 version of call
$dte = [datetime](Get-DatePicker)
Get-EventLog -LogName application |
Where-Object { $_.timeWritten -gt $dte } <\/FONT>\n

<\/FONT><\/SPAN>When the Get-DatePickerFunction.ps1 script runs, the very small dialog box seen here appears: <\/P>\n

\"Image 
<\/SPAN>
By keeping the dialog box small and unobtrusive, it makes the control easy to use. To use the control, you click the drop-down arrow on the far right of the control. When you do, a calendar that displays the current month appears. (Full disclosure: This post was written in August, so this did <\/EM>display the current month when I was writing this post.) This is seen here: <\/P>\n

\"Image<\/FONT><\/A><\/SPAN> <\/P>\n

When you pick a date from the calendar, the selected date that is displayed in the Windows form will change. This is seen here: <\/P>\n

\"Image
<\/SPAN><\/P>\n

Once you click the Close <\/B>button in the upper right corner, the date is submitted back to the script. Simplicity, elegance, and refinement in a small, easy-to-reuse function. <\/P>\n

The Get-DatePickerFunction.ps1 script begins by creating a function named Get-DatePicker<\/B>. This function does not accept any parameters. To create the Get-DatePicker<\/B> function, you only need to use the Function<\/B> keyword and specify the name of the function. The function then opens a script block by using the opening curly brackets. This is seen here: <\/P>\n

Function Get-DatePicker
{   <\/SPAN><\/FONT>\n

<\/SPAN>Now you will need to load the System.Windows.Forms<\/B> .NET Framework assembly. This assembly is required for Windows PowerShell to provide access to the .NET Framework classes in the System.Windows.Forms<\/B> .NET Framework namespace. By default the System.Windows.Forms<\/B> assembly is not loaded and the classes from the System.Windows.Forms<\/B> .NET namespace are not available. Many of the graphical classes that Windows PowerShell can use reside in the System.Windows.Forms<\/B> namespace (but not all of them). The use of the LoadWithPartialName<\/B> static method from the System.Reflection.Assembly<\/B> .NET Framework class was discussed yesterday<\/A>. <\/P>\n

In Windows PowerShell 2.0, you can use the Add-Type<\/B> cmdlet to load the assembly. This is seen here:
<\/P>\n

Add-Type \u2013AssemblyName System.windows.forms <\/FONT>\n

<\/SPAN>The LoadWithPartialName<\/B> static method works on both Windows PowerShell 2.0 and on Windows PowerShell 1.0. The resulting confirmation message from the command is piped to the Out-Null<\/B> cmdlet to avoid cluttering the screen. This is seen here: <\/P>\n

 <\/SPAN>[System.Reflection.Assembly]::LoadWithPartialName(“System.windows.forms”) |
 <\/SPAN>Out-Null <\/FONT>\n

<\/SPAN>A new instance of the .NET Framework Windows.Forms.Form<\/B> class is created by using the New-Object<\/B> cmdlet. The resulting object is stored in the $WinForm<\/B> variable. The Windows.Forms.Form<\/B> .NET Framework class is documented on MSDN,<\/A> and it will be used to host the date picker control that you will create later.  <\/SPAN>The Form<\/B> class is created here: <\/P>\n

 <\/SPAN>$WinForm = New-Object Windows.Forms.Form   <\/SPAN><\/FONT>\n

<\/SPAN>You can assign any title you wish to for the Windows.Forms.Form<\/B> by assigning a value for the text<\/B> property. This is seen here: <\/P>\n

 <\/SPAN>$WinForm.text = “DatePicker Control”   <\/SPAN><\/FONT>\n

<\/SPAN>After you have created the Windows.Forms.Form<\/B> class, you will need to create an instance of the System.Drawing.Size<\/B> structure. The System.Drawing.Size<\/B> .NET Framework structure is used to store the width and the height of the rectangular dimensions of the Windows.Forms.Form<\/B>. These dimensions are assigned to the Size<\/B> property of the Form<\/B>. The Size<\/B> dimensions must be supplied as an instance of the System.Drawing.Size<\/B> class. This is seen here: <\/P>\n

 <\/SPAN>$WinForm.Size = New-Object Drawing.Size(205,55) <\/FONT>\n

<\/SPAN>The previous .NET Framework classes are required for most Windows PowerShell projects that create graphical interfaces. To create a date picker, we will need to create an instance of the System.Windows.Forms.DateTimePicker<\/B> control. The DateTimePicker class<\/FONT><\/A> is documented on MSDN. <\/P>\n

 <\/SPAN>$DatePicker = New-Object System.Windows.Forms.DateTimePicker   <\/SPAN><\/FONT>\n

<\/SPAN>After the DateTimePicker<\/B> control has been created, it is added to the Controls<\/B> collection of the Form<\/B> class. Once the DateTimePicker<\/B> control is added to the Controls<\/B> collection, the Add_Shown<\/B> method is used to add to the active Form<\/B>. The ShowDialog<\/B> method from the Windows.Forms.Form<\/B> class is used to display the dialog. This is seen here: <\/P>\n

$WinForm.Controls.Add($DatePicker)
$WinForm.Add_Shown($WinForm.Activate())  <\/SPAN>
$WinForm.ShowDialog() | Out-Null  <\/SPAN><\/FONT>\n

<\/SPAN>Once the Form<\/B> with the DateTimePicker<\/B> control is displayed, the value that is returned is the date that is selected from the control. The DateTimePicker<\/B> control value property returns an instance of a DateTime<\/B> class. After the value is returned, the function ends: <\/P>\n

 <\/SPAN>$DatePicker.value
} #end function Get-DatePicker <\/FONT>\n

<\/SPAN>RS, we are now finished creating the Get-DatePicker<\/B> function. How can we use it? Because it returns a System.DateTime<\/B> structure, which is documented on MSDN<\/FONT><\/A>, you can use it the same way you use any other date in Windows PowerShell. In Windows PowerShell 1.0, for example, you might want to use the Get-DatePicker<\/B> function to allow you to choose the beginning date to peruse the event logs. In your code, you store the date that is returned from the Get-DatePicker<\/B> function into a variable called $dte<\/B>. You then use the Get-EventLog<\/B> cmdlet to retrieve all of the events from the application log on your local computer. You next pipe the resulting event log entries to the Where-Object<\/B> cmdlet that sorts through the events based upon a timeWritten<\/B> property value that is greater than the date value stored in the $dte<\/B> variable. This is seen here: <\/P>\n

$dte = [datetime](Get-DatePicker) <\/FONT><\/P><\/SPAN>\n

Get-EventLog -LogName application | <\/FONT><\/P><\/SPAN>\n

Where-Object { $_.timeWritten -gt $dte } <\/FONT>\n

<\/SPAN>The above command, which is at the bottom of the Get-DatePickerFunction.ps1 script, returns the event log entries seen here: <\/P>\n

\"Image<\/FONT><\/A><\/SPAN> <\/P>\n

If you are running Windows PowerShell 2.0, it is even easier to search the event log (and it can also be targeted at a remote computer by using the \u2013computername<\/B> parameter) because there is an after<\/B> parameter. This functionality serves two purposes. It filters at the log level instead of returning everything to Windows PowerShell to make the Where-Object<\/B> do the work, and also it makes writing the script code easier. This simplified syntax is seen here: <\/P>\n

Get-EventLog -LogName application -After [datetime](Get-Datepicker) <\/FONT>\n

<\/SPAN>RS, we are taking a five-minute break from the meeting. I need to head downstairs and make some Earl Grey tea<\/FONT><\/A>, grab an ANZAC biscuit<\/FONT><\/A>, and get back upstairs so that I can jump back on the conference call. Thanks for a great question! <\/P>\n

Join us tomorrow as Graphical Windows PowerShell Week continues. If you want to know what we will be discussing tomorrow, follow us on Twitter<\/A> or Facebook<\/A>. If you have any questions, send e-mail to scripter@microsoft.com<\/FONT><\/A> or post on the Official Scripting Guys Forum<\/A>. See you tomorrow. Until then, keep on scripting. <\/P>\n


Ed Wilson and Craig Liebendorfer, Scripting Guys<\/SPAN><\/B> <\/P>\n

<\/FONT> <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

Share this post: Hey, Scripting Guy! I hate typing dates. There are several ways of typing dates, and they are all a pain. I do not like having to type the numbers and the whacks, and I do not like having to spell out month names, or attempting to remember if it is month first […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[71,3,4,45],"class_list":["post-52553","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-graphical","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Share this post: Hey, Scripting Guy! I hate typing dates. There are several ways of typing dates, and they are all a pain. I do not like having to type the numbers and the whacks, and I do not like having to spell out month names, or attempting to remember if it is month first […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=52553"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/52553\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=52553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=52553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=52553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}