In have the follow script:
[system.reflection.assembly]::loadwithpartialname('microsoft.visualbasic') | Out-Null $Country = [microsoft.visualbasic.interaction]::inputbox('Fill in the Country name in the short OU version','Country') $StartDate = [microsoft.visualbasic.interaction]::inputbox('Fill in the begin date of the month','Given Date') $EndDate = [microsoft.visualbasic.interaction]::inputbox('Fill in the last date of the month','Last Date') $fileLocation = [microsoft.visualbasic.interaction]::inputbox('give up filelocation were to save the file','Save As','c:\temp\data.csv') $SDate = get-date $StartDate $EDate = get-date $EndDate $OurUsers = Get-ADUser -SearchBase "OU=$country,DC=corp,DC=local" -filter * -Properties * $OurUsers | Where-Object {($_.whencreated -ge $StartDate) -and ($_.Whencreated -le $EndDate)} | Select-Object @{Name="AD DisplayName";Expression={$_.CN}}, @{Name="Accountname";Expression={$_.SamAccountName}},@{Name="Creation Date";Expression={$_.WhenCreated}}, @{Name="internal or external";Expression={$_.Extensionattribute6}}, @{Name="E-mail(if General account field can be Empty)";Expression={$_.Mail}}, @{Name="Notesfield";Expression={$_.Info}}, AccountExpirationDate, PasswordNeverExpires, CannotChangePassword, PasswordNotRequired| Sort-Object whencreated -Descending | Export-Csv $fileLocation -Delimiter ";"
When i run this i get the follow message
Could not compare “01/25/2018 10:45:18” to “31-1-2018”. Error: “Cannot convert value “31-1-2018” to type “System.DateTime”. Error: “String was not recognized as a valid DateTime.””
At line:17 char:27
- $OurUsers | Where-Object {($.whencreated -ge $StartDate) -and ($.Whencreated - …
-
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- CategoryInfo : InvalidOperation: (
, RuntimeException
- FullyQualifiedErrorId : ComparisonFailure
- CategoryInfo : InvalidOperation: (
I know the problem comes from the line:
$OurUsers | Where-Object {($_.whencreated -ge $StartDate) -and ($_.Whencreated -le $EndDate)} |
Any one know what must be filled in.