topic Copying custom date values to date property error in APIs & Integrations

Copying custom date values to date property error

EddBrisley — Thu, 23 May 2024 09:50:17 GMT

Interesting one today!

I've got a workflow with a custom code element which retrives the hs_timestamp value (in the format '2024-01-10T16:00:00Z'), and that all works fine.

Up until about April, I was able to successfully copy this datetime output to a date property within the workflow. However! it then started generating the error for seemingly no reason:

"Unable to update property because property value isn't valid"

I've tried converting the timestamp value into a unix value, but no cigar.

Anyone have any idea as to what caused this change, and if there are any solutions/alternatives?

Many thanks in advance crew 🙂

Re: Copying custom date values to date property error

SteveHTM — Thu, 23 May 2024 16:02:07 GMT

@EddBrisley - I don't know how picky the format conversions are, but I ended up using date stamp values formatted as "%Y-%m-%dT%H:%M:00.000Z" - looks like there is an extra decimal place usage vs your reported format.

I don't have any insight into what may have changed recently with date handling.

Steve

Re: Copying custom date values to date property error

EddBrisley — Fri, 24 May 2024 09:52:46 GMT

Hi @SteveHTM , thanks for your response.

I've just tested with the extra decimal place, and that doesn't seem to be it. Thanks anyway, I'll keep digging, if I find out what's up I'll post here 👍

Re: Copying custom date values to date property error

KimM — Wed, 29 May 2024 12:58:10 GMT

I actually built a workflow the other day and ran into this issue.

Couple of things I noted:

When copying the date or date/time properties that you've fetched via an API call you must convert to a date object and then getTime() for the millisecond timestamp
If you're copying this value to a date property (not a date time property) you have to set the hours, minutes, seconds and milliseconds to 0. It will only accept round dates, even if in millisecond timestamps.

Below is a code sample of how I went about this:

timestamp = apiResponse.results[0]["properties"]["hs_timestamp"]; const dateObject = new Date(timestamp); dateObject.setUTCHours(0, 0, 0, 0); timestamp = dateObject.getTime();

I was specifically using the results from an API call, so need to convert it to a date object first to be able to manipulate it.

Hope this helps.