So i've found a flaw in the Podio Date fields when updating them via the API and its rather frustrating.
When getting and setting Date fields via the API it pulls/requires it to be set, in UTC time. It then converts to the user's Timezone based on their profile.
HOWEVER, if you set the Date field to midnight (00:00:00), it ignores time completely and will always just leave it as the day, not auto converting it to the correct time. (For example, 6/29/17 00:00:00, should convert to 6/28/17 18:00:00 for me in MST, but it just stays as 6/29/17 in Podio)
This is highly frustrating when trying to develop automations. For example I am taking the a date field, adding days/hours to it, and if it happens to land on 12:00 am, even though I want it to convert back to local timezones in Podio, it just stays on the day. I thought maybe adding some seconds to it might cause this behavior to change, however, both 00:00:01, and 00:00:59, both have the same result.
The only work around was to add 1 minute more. This is not a good solution, however the only one I was able to find.
Is there a way to resolve this?