How to add the timestamp of a workflow in a particular format in googlesheet

[Siddarth_Jaiswal]

I want to add the timestamp of a workflow in a particular format in googlesheet
Format is: 12/12/2022 18:06:50

I want in Local time zone & in 24 Hr format

These 4 are not in the format which I require in

1. {{pc_utc_human_now}}
   This function will output the current time in UTC Time Zone.
   Example: 09/08/2021 03:29AM
   
   
2. {{pc_local_human_now}}
   This function will output the current time in your local time zone. The local time zone needs to be set up in your Account Settings.
   Example: 09/08/2021 08:59AM
   
   
3. {{pc_utc_timestamp_now}}
   This function will output the current time in UTC Time Zone.
   Example: 1631071769
   
   
4. {{pc_local_timestamp_now}}
   This function will output the current time in your local time zone. The local time zone needs to be set up in your Account Settings.
   Example: 1631091582

 

[PabblyMember4]

Hey @Siddarth_Jaiswal

Please check the below screenshot and make the changes as per your requirement. You can click on Map On and type the date for format in which you want the date and time.

 

[ichilddev]

Hey @Siddarth_Jaiswal

Please check the below screenshot and make the changes as per your requirement. You can click on Map On and type the date for format in which you want the date and time.

View attachment 19103

Hi

I have used your method, and using {{pc_utc_human_now}} to convert to a local Singapore time. 14 Jan 2023 18:36.
However when i add 7 days to this time, the time is not correct. i.e 19 Jan 2023 18:35?

See attached.

Any advice how to include the the correct time?

 

[PabblyMember4]

Hey @ichilddev

Please let me know the workflow name to check the scenario. You might be entering the wrong date and timezone format because of which you are getting this value. Kindly share the details for checking it.

 

[ichilddev]

Work Flow Name: Create Deposit

Hey @ichilddev

Please let me know the workflow name to check the scenario. You might be entering the wrong date and timezone format because of which you are getting this value. Kindly share the details for checking it.

 

[ichilddev]

Hey @ichilddev

Please let me know the workflow name to check the scenario. You might be entering the wrong date and timezone format because of which you are getting this value. Kindly share the details for checking it.

Hi hi anyupdate?

 

[PabblyMember4]

Hey @ichilddev

We have checked the workflow by name Create Deposit and we did not find any workflow by that name. Also we have check the workflow that we found in your account and we did not find the action step there. Please let me know the actual step to check the scenario.

Thanks
Kunal

 

[ichilddev]

Hey @ichilddev

We have checked the workflow by name Create Deposit and we did not find any workflow by that name. Also we have check the workflow that we found in your account and we did not find the action step there. Please let me know the actual step to check the scenario.


View attachment 20447

Thanks
Kunal

It is V4 Create Deposit PDF &/Or Send Deposit

 

[PabblyMember4]

Hey @ichilddev

We have corrected the issue in your workflow and it is showing the date and time correctly. Please check the below screenshot:-

Thanks
Kunal

 

[ichilddev]

Hey @ichilddev

We have corrected the issue in your workflow and it is showing the date and time correctly. Please check the below screenshot:-

View attachment 20549

Thanks
Kunal

Oh let me check. Thanks

 

[ichilddev]

Hey @ichilddev

We have corrected the issue in your workflow and it is showing the date and time correctly. Please check the below screenshot:-

View attachment 20549

Thanks
Kunal

Hi We have this issue again. After following your earlier advises, it works when converting to local time. Today it seems off. Please see screenshot.

 

[PabblyMember4]

Hey @ichilddev

We have corrected the issue. Kindly make sure that you are entering the From Format date correctly.

Thanks
Kunal

 

[ichilddev]

Hey @ichilddev

We have corrected the issue. Kindly make sure that you are entering the From Format date correctly.

View attachment 21232

Thanks
Kunal

Hi Please see attached. The issue still persists and the time is not correct!

 

[ichilddev]

Hey @ichilddev

We have corrected the issue. Kindly make sure that you are entering the From Format date correctly.

View attachment 21232

Thanks
Kunal

Hi Please see attached.

The result is very inconsistent. At times it shows correctly. Compare the 2 time stamp at SG Time 843am and 914am, time result is not consistent.

 

[ichilddev]

Hey @ichilddev

We have corrected the issue. Kindly make sure that you are entering the From Format date correctly.

View attachment 21232

Thanks
Kunal

Hi

What happens to the attached configuration when i used {{pc_utc_human_now}} and From TImeZone = Singapore, will the user's actual time be correct if he/she is using the system if not inside Singapore timezone i.e +8:00

Or Should I use UTC instead of Africa? I have used Africa because I have followed one of the advisor in the community.

 

[PabblyMember4]

Hey @ichilddev

Please allow me day's time to check the issue with the team and reply back with an update.