Problem to upload the date picker property

[kaleperez]

When I send an specific date picker property update converted in UnixTimeMilliseconds, HubSpot shown the date with one day less. I don't know what's the cause of this.

I tried different methods to convert the date to UnixTimeMilliseconds. I also included the UTC just in case, but the problem continues. Sometime the date is including correctly and other time is including with one day less. 

This is an example the method that I use to convert the date:

DateTimeOffset.Parse(mydate.FromUTC("Central Standard Time").ToString()).ToUnixTimeMilliseconds().ToString()

Thanks in advanced for your help

[webdew]

Hi @kaleperez ,

Hubspot Accept below format to store data. please passed below code of php.
<?php
$time = time() * 1000;


OR

<?php
$myDate = new \DateTime('m/d/Y', new \DateTimeZone('UTC'));
$hubSpotDate = $myDate->format('Y-m-d g:i a');

?>

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

[kaleperez]

Thanks for this solution. Do you have any solution using c#?. We don't use php code in our site.

I just test using only date, deleting the time, but it still not working.

DateTimeOffset.Parse(myDate.ToShortDateString()).ToUnixTimeMilliseconds().ToString()

Thanks.

[dennisedson]

@gotmike 

Could you assist?

[dennisedson]

@miljkovicmisa , feel like helping a out a friend in need?

[miljkovicmisa]

👋 @dennisedson and @kaleperez, I would love to help but unfortunately C# is not my thing, all I can do is JavaScript and PHP...

[dennisedson]

You have the weekend to get up to speed, sir 😉