Set the start time of a converted project

[Tracy_Parmeter]

Trying to set the time of projects converted from issues using automation to 9:00am.

We have an Update Record Module > Record Type Project > Planned Start Date Field.

setHour(35.plannedStartDate;9)

This works and changes the hours but the minutes still use whatever minute it was when the project was created. We tried to add setHour(35.plannedStartDate;9),setMinute(35.plannedStartDate;0) but it fails.

Anyone know how I can accomplish this?

[Heather_Kulbacki · Accepted solution]

@Tracy_Parmeter it's about as clear & intuitive as mud (in my opinion), but this should do it:

{{setMinute(setHour(35.plannedStartDate;9);00)}}

If someone else can explain to me why they need to be nested like that, I'm interesting in soaking in that info.

[Tracy_Parmeter]

Heather, that worked, thank you so much!

[RandyRoberts]

According to ChatGPT:

1. The code starts with the "plannedStartDate" variable or property, which presumably contains a date or timestamp value.

2. The "setHour" function is called on the "plannedStartDate" value, with 9 as the second argument. This means that the "setHour" function will set the hour of the timestamp to 9.

3. The result of step 2 is then passed as the first argument to the "setMinute" function, with "00" as the second argument. This means that the "setMinute" function will set the minute of the timestamp to 0.

4. The final result of the code is the updated timestamp with the hour set to 9 and the minute set to 0.

[NicholasPa1]

Hi,

I have a question regarding the setHour function in Fusion.

It doesn't appear to be working correctly as implemented.

If I have a timestamp of a task come over from Workfront in say, 

 T22:00:00:000Z or T21:00:00:000Z, the set hour doesn't set it to the hour I prefer.

What's happening is that these timestamps in Workfront are in GMT.  My understanding is that GMT does not observe DST.

Regardless, if I use the setHour function such as:

setHour(plannedCompletionDate; 20) where the planned completion date is the planned completion date of our tasks coming over from Workfront,  it should set it to 20:00:00 EST for all of the incoming planned completion date timestamps, instead we are getting results in either 12 am est or 1 am est.

Just want to confirm my understanding as the setHour should force or set the incoming hour in Fusion.

Thank you,

Nick