AnsweredAssumed Answered

Date Conversion problem

Question asked by rogelio.tan on Mar 19, 2017
Latest reply on Mar 22, 2017 by chris.ben

Hi Everyone,

 

I'm having trouble extracting the proper value of a date I converted. First the user will log an event and it has a Start Time (UTC) and End Time (UTC). I also have a Calculated Value control that will convert it to different timezone which is Cluj, Romania and Manila, Philippines timezone. +8 for Philippines and +2 for Romania. 

 

formatDate(dateAddHours(Start Time (UTC), 8),"MM/dd/yyyy hh:mm:ss tt")

formatDate(dateAddHours(End Time (UTC), 8),"MM/dd/yyyy hh:mm:ss tt")

formatDate(dateAddHours(Start Time (UTC), 2),"MM/dd/yyyy hh:mm:ss tt")

formatDate(dateAddHours(End Time (UTC), 2),"MM/dd/yyyy hh:mm:ss tt")

 

when I open the event the calculations are correct.

 

Now here's my problem I have this workflow that is working fine. I just recycle it and change the variables so that I can get the values in the field of the needed dates. when I email it to myself here is the output.

 

the form is working fine and I will just get the specific date. But still I'm getting those wrong values.

 

I attached the workflow and form just in case you want to check.

 

Thank you in advance!

Outcomes