API Date & Time

Marilen.Navarro103391

Hello- Can you assist me?

1. How do I convert the "Date Completed" to US Eastern Date/Time
2. What's the formula for getting the amount of time spent between Date Created and Date Completed, in Days/Mins/Seconds.

Thank you.

Marilen.Navarro103391

@Genevieve P. Can you please assist me? Thanks

Marilen.Navarro103391

@Andrée Starå Can you assist me please?

Kelly Moore

Hey @Marilen.Navarro103391

If you're doing this through Bridge, I can offer how I do this. If you're using the API, sorry, I can't help. I did see the syntax of a timezone string shown in the API documentation here: https://smartsheet.redoc.ly/tag/users#operation/get-current-user

For a Bridge routine, here's an excerpt from one of my workflows where I wanted a timestamp in a specific timezone. Note that I customized the date and time format to fit the needs of the sheet I was updating. Also note the word 'formatted' must be added to the final Value string.

For date and time calculations, you may find this post by Paul helpful. Smartsheet views timestamps as a text string so you first must parse out the hours, minutes and seconds, then do math on each component.

Hope this helps

Kelly