Skip to main content
richas0003
August 19, 2022
Question

date zone comparison

  • August 19, 2022
  • 3 replies
  • 0 views

I want to compare the different time zone applied all possible functions but not getting the actual output:

"2022-08-19T12:33:52.4670000Z" <= now()

I applied gmt function but getting output like this 

  • Date out of range (2147483647)

    3 replies

    harshitb6843
    August 19, 2022

    To understand the problem better, do you want to get the date time difference between two dates of different timezones?

    richas0003
    August 19, 2022

    a!localVariables(

    local!apiResponse : rule!TCT_DocuSign_GetEnvelopeDefinition(envelopId: "eddc7569-2fe2-4667-b143-8e45f436489358eb9"),
    local!expireAfter:index(index(local!apiResponse,"result",{}),"expireDateTime",{}),
    local!isExpired: if(not(isnull(local!expireAfter)),
    local!expireAfter <= now(),
    false
    ),)

    this is my code but value in local!ExpiredAfter is 2022-08-19T12:33:52.4670000Z and now() is 8/19/2022 2:56 AM PDT

    stefanhelzle0001
    Brainy
    August 19, 2022

    Try this recipe to parse the ISO date before comparing it.

    docs.appian.com/.../Function_Recipes.html