Outbound : Convert seconds to UTC Time and vice versa

To convert date from export file to seconds passed after 01/01/1970 in Genesys format)

       Dim sDate As String = “01/06/2011 16:46:44”
       Dim date1 As Date = #1/1/1970#

       Dim date2 As Date = DateTime.Parse(sDate).ToUniversalTime

       inSeconds = DateDiff(“s”, date1, date2))

To convert seconds from database to date and time

        Dim localTime As Date

        Dim date1 As Date = #1/1/1970#

        localTime = date1.AddSeconds(1306943204).ToLocalTime

        Debug.Print localtime.ToString

(Visited 11 times, 1 visits today)

Comments: 7

  1. Floyd June 24, 2015 at 3:30 am Reply

    Hi! Really liked your blog and really informative. Just wanted to ask, how do I change the date format in Genesys 8.5 version? Currently it is configured as mm/dd/yyyy and we would want it to be dd/mm/yyyy. Silly question but I cant seem to find the answer.

    • blakshmikanth June 24, 2015 at 10:11 am Reply

      Where do you want to change like Pulse, CME, GA or GAX?

  2. Floyd June 24, 2015 at 3:30 am Reply

    Hi! Really liked your blog and really informative. Just wanted to ask, how do I change the date format in Genesys 8.5 version? Currently it is configured as mm/dd/yyyy and we would want it to be dd/mm/yyyy. Silly question but I cant seem to find the answer.

    • blakshmikanth June 24, 2015 at 10:11 am Reply

      Where do you want to change like Pulse, CME, GA or GAX?

      • Floyd July 1, 2015 at 2:56 am Reply

        We would want the reports on the Web tool to be on the dd/mm/yyyy format. I cant locate where to change the setting for this. Also, if you can point me to how to change the date format as well in GAX, that would really help. Thanks for the reply by the way.

Leave a Reply

Your email address will not be published. Required fields are marked *