How can I convert a text having a timestamp format to a timestamp?

回答済み


投稿日時:2022年12月01日

Hello there, 

Please is there any function on explore that could allow me to convert a text in this format "2022-11-21T15:19:18" to a timestamp.. Indeed I need this in order to catch the first reply time on a ticket when an outbound call happened (generating automatically a private note that the normal first reply time metric can't catch).. Our technology team could implement a trigger that catches that exat timestamp when the outbound call took place but that trigger could be only stored in a text field.. so now the issue is on how to convert that text to a timestamp and then calculating the difference between it and the ticket created timestamp ..

Thanks!!


0

6

0件のコメント

サインインしてコメントを残します。

お探しのものが見つかりませんか?

新規投稿