Convert a string to datetime in PowerShell

ParseExact is told the format of the date it is expected to parse, not the format you wish to get out.

$invoice = '01-Jul-16'
[datetime]::parseexact($invoice, 'dd-MMM-yy', $null)

If you then wish to output a date string:

[datetime]::parseexact($invoice, 'dd-MMM-yy', $null).ToString('yyyy-MM-dd')

Chris

Related Posts:

  1. Connect-AzAccount – how to avoid azure device authentication?
  2. How do I concatenate strings and variables in PowerShell?
  3. PowerShell equivalent to grep -f
  4. Running a command as Administrator using PowerShell?
  5. Setting Windows PowerShell environment variables
  6. How do I concatenate strings and variables in PowerShell?
  7. Replace substring in PowerShell
  8. Echo equivalent in PowerShell for script testing
  9. Echo equivalent in PowerShell for script testing
  10. PowerShell says “execution of scripts is disabled on this system.”
  11. How to use the curl command in PowerShell?
  12. PowerShell and the -contains operator
  13. Change directory in PowerShell
  14. How to handle command-line arguments in PowerShell
  15. Splitting a string into separate variables
  16. How to split string by string in Powershell
  17. How to split string by string in Powershell
  18. How to export data to CSV in PowerShell?
  19. Downloading a file with PowerShell
  20. Terminating a script in PowerShell
  21. How to run an EXE file in PowerShell with parameters with spaces and quotes
  22. How to run an EXE file in PowerShell with parameters with spaces and quotes
  23. Terminating a script in PowerShell
  24. Prompt for user input in PowerShell
  25. How to upgrade PowerShell version from 2.0 to 3.0
  26. How do I concatenate strings and variables in PowerShell?
  27. Array.Add vs +=
  28. PowerShell and the -contains operator
  29. PowerShell string interpolation syntax
  30. How to write to the console in PowerShell?
  31. Function return value in PowerShell
  32. PowerShell ‘Or’ Statement
  33. powershell -Or operator not working
  34. How to decode a Base64 string?
  35. Copy file remotely with PowerShell
  36. How to find the Windows version from the PowerShell command line
  37. Read file line by line in PowerShell
  38. Path to Powershell.exe (v 2.0)
  39. Azure Powershell Select-AzureSubscription with subscription id
  40. How to unzip a file in Powershell?
  41. You cannot call a method on a null-valued expression
  42. How can I replace every occurrence of a String in a file with PowerShell?
  43. Unix tail equivalent command in Windows Powershell
  44. Create directory if it does not exist
  45. Copy-Item is overwriting by default
  46. The term ‘Get-ADUser’ is not recognized as the name of a cmdlet
  47. How to print environment variables to the console in PowerShell?
  48. The term ‘nmake’ is not recognized
  49. Ternary operator in PowerShell
  50. Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  51. Call PowerShell script PS1 from another PS1 script inside Powershell ISE
  52. Does PowerShell has something like “echo off” and “echo on” trigger?
  53. LDAP query in PowerShell
  54. PowerShell: Comparing dates
  55. Press any key to continue
  56. accessing the $args array in powershell
  57. Create a function with optional call variables
  58. How do I do ‘dir /s /b’ in PowerShell?
  59. Create Log File in Powershell
  60. What does the & symbol in powershell mean?
  61. What does the double asterisks mean?
  62. How to enter a multi-line command
  63. How to break lines in PowerShell?
  64. How to tell PowerShell to wait for each command to end before starting the next?
  65. How to convert string to integer in PowerShell
  66. Powershell: GetType used in PowerShell, difference between variables
  67. One Powershell Script calling another with parameters
  68. Concatenate files using PowerShell
  69. Passing multiple values to a single PowerShell script parameter
  70. Upload files with FTP using PowerShell
  71. Powershell send-mailmessage – email to multiple recipients
  72. Sometimes PowerShell stops sending output until I press enter. Why?
  73. In a PowerShell script, how can I check if I’m running with administrator privileges?
  74. What is the literal escape character in Powershell?
  75. Python datetime to string without microsecond component
  76. Datetime strptime in python
  77. Convenient way to deal with ValueError: cannot reindex from a duplicate axis
  78. Converting string into datetime
  79. How to get current timestamp in string format in Java? “yyyy.MM.dd.HH.mm.ss”
  80. What’s the difference between ISO 8601 and RFC 3339 Date Formats?
  81. How to get the current date/time in Java
  82. How to get the current time in Python
  83. How can I pass an argument to a PowerShell script?
  84. Convert date yyyyMMdd to system.datetime format
  85. Sql Server string to date conversion
  86. Add days to JavaScript Date
  87. Convert datetime to Unix timestamp and convert it back in python
  88. How to insert date values into table
  89. Validate date in dd/mm/yyyy format using JQuery Validate
  90. How to convert an Instant to a date format?
  91. How can I test that a variable is more than eight characters in PowerShell?
  92. Adding hours to JavaScript Date object?
  93. Subtract one day from datetime
  94. How do I get the current username in Windows PowerShell?
  95. Get current year in TSQL
  96. Get current time in milliseconds in Python?
  97. Creating a range of dates in Python
  98. Simple PowerShell LastWriteTime compare
  99. Get Current Time in mm/dd/yyyy in C++
  100. How to zip/unzip files in Powershell?

Leave a Comment

tech