ConnectWise time normalization

[mrmarkwest]

In trying to do a Create-CWConfig function, I ran into this terrible annoyance with the way that CW needs to receive [datetime] via the API. I wrote this little function that helps. Figured it would help you and your users so they didn't bang their head against the same problems I did.

function ConvertTo-CWTime
{
Param
(
[Parameter(Mandatory = $True,Position = 0)]
[datetime]$dateTime
)
$MyTZone = Get-TimeZone
$datetime = "{0:yyyy-MM-ddThh:mm:ssZ}" -f [System.TimeZoneInfo]::ConvertTimeToUtc($dateTime, $MyTZone)
return $datetime
}

[BrianBtheITguy]

This may have been repaired as I just used:

Add-CWTimeEntry -TicketID 140830 -MemberID 150 -Start "April 6, 2017 8:00:00 AM" -End "April 6 2017 5:00:00 PM" -Message @"MULTILINE STRING"@ -AddToDescription

with no issue. Either there is a specific issue with Create-CWConfig (which I don't see in the repository), your PC's Region/Language settings, or it's gone away.

Regardless thanks for the tip. Added this to my scripts folder. :)

[mrmarkwest]

Thanks sir, trying to figure out how to contribute... As I'd really like to add on what I've done and not re-do what you have already done.

[mrmarkwest]

So, I've come across this issue again, when I am attempting to create an Agreement.

  "code": "UnsupportedFormat",
  "message": "Unsupported format applied to startDate",
  "resource": "agreement",
  "field": "startDate"

I wonder if it is that I am only needing to pass a date in my example, and you have to define time as well. hmm..

[sgtoj]

@mrmarkwest I welcome contributions. You will need to fork master, commit the changes to your fork, then submit pull requests.

[BrianBtheITguy]

If you check out page #41 you will see that some other issues like this. I think it has to do with Zulu time being used instead of local time.