Date Format in Fusion

[abartimmo1]

How do i format this date /Date(1675832400000-0500)/ in Fusion?

[Rafal_Bainie]

I would expect this to work:

but I got this in response, so I'm not sure if that is a valid date:

[Richard_Le_]

Hi,

This looks like a Unix ms timestamp. Try parsing the date and specifying "x" (which represents Unix) as the format, and nest that into a format date function. It would look something like this:

The only thing i'm not sure of is the -0500 which I guess is meant to represent timezone. Unix timestamps in their very nature are timezone independent, so the date you have provided (1675832400000-0500) is not a valid format. I suspect that you will need to trim this value down to read only the date/time element of this string (everything preceding "-0500") and then apply the relevant timezone adjustments in another function or a subsequent module.

Hope this helps.

Best Regards,

Rich. 

[RandyRoberts · Accepted solution]

Richard is correct in that the 0500 represents time zone offset.

In Make, formerly Integromat (what Fusion is based on), you can use the parseDate function to parse a timestamp with a timezone offset. The parseDate function takes three arguments: text, format, and timezone. The first argument is the text value representing the date, the second argument is the format of the date, and the third argument is an optional timezone.

Here’s an example:

parseDate("1675832400000-0500"; "xZ"; "UTC")

This will parse the timestamp “1675832400000-0500” using the format “xZ” (where “x” represents an epoch timestamp in milliseconds and “Z” represents a timezone offset) and return a Date value in UTC.

More HERE

[Richard_Le_]

Nice Randy. 

[RandyRoberts]

The Make help center has WAY better documentation than Fusion has. It isn't Workfront specific like Fusion but it's still super useful.

Make Help center

[abartimmo1]

That worked great - thank you, Randy