Powershell export date data to CSV.

Question

Powershell export date data to CSV.

Kalaimani Thirupathi 411

Dear All,

I'm not able to export the date and time using Powershell. Kindly help me with this, please.

PS C:\> $Output
WeeklySchedule DaysOfTheWeek : {Wednesday, Saturday, Friday, Sunday}
MonthlySchedule RetentionScheduleWeekly DaysOfTheWeek : {Wednesday, Sunday}
MonthlySchedule RetentionScheduleWeekly WeeksOfTheMonth : {Last, First}
YearlySchedule MonthsOfYear : {January} :
YearlySchedule RetentionScheduleWeekly DaysOfTheWeek : {Sunday}
YearlySchedule RetentionScheduleWeekly WeeksOfTheMonth : {Last}

but when I export to csv getting the below error

Rich Matheisen 47,901 Reputation points

2021-09-03T15:17:35.7+00:00

In what format are the data in the data you're exporting? It appears to be you're trying to export a "enum" (system.dayofweek, system.dayofweek, OR a piece of JSON code. You'll have to put those into "string" format to place them in a CSV.

Posting the code and a sample of the data would be helpful.

Even more helpful would be to know what properties are present. Try "gm -InputObject $Output", or if it's an array of objects "$Output[0] | gm".

Also, when you post code, use the "Code Sample" editor (it's the 5th from the left, with the "101 010" icon).

1 answer

Your answer

Rich Matheisen 47,901 Reputation points

2021-09-03T15:17:35.7+00:00

In what format are the data in the data you're exporting? It appears to be you're trying to export a "enum" (system.dayofweek, system.dayofweek, OR a piece of JSON code. You'll have to put those into "string" format to place them in a CSV.

Posting the code and a sample of the data would be helpful.

Even more helpful would be to know what properties are present. Try "gm -InputObject $Output", or if it's an array of objects "$Output[0] | gm".

Also, when you post code, use the "Code Sample" editor (it's the 5th from the left, with the "101 010" icon).

Answer 1

Hello @Kalaimani Thirupathi

Have you tried:

$CurrentDate = Get-Date
$CurrentDate = $CurrentDate.ToString('MM-dd-yyyy_hh-mm-ss')
Get-CsAdUser -OU "OU=OUName,OU=OUName,DC=this,dc=is,dc=my,dc=domain" |
Where-Object {$.Name -like "AA*" -or $.Name -like "BB*" -and $.Enabled -ne $TRUE } |
Export-Csv -Path "D:\EnableLyncUsers\ExportsByDate\AABBAccounts$CurrentDate.csv"

It is not very clear why or how you want to retrieve date and time, but a bit more explaination could help the community to guide you.

Hope this code helps you,
Best regards,

Share via

Powershell export date data to CSV.

1 answer

Your answer