Date and time comparison

harshc5309 7 months ago

I am having date and time of submitted form in Date time format.
I want to compare the date and time if it exceeds 1 hr from submission I want to show a proceed button.

How I can give a condition where it is comparing submitted form have completed 1hr

Discussion posts and replies are publicly visible

Top Replies

gopalt0943 7 months ago +1

Assume the variable "submissionDatTime". that holds the submitted date and time. then, after you want to show the proceed button, if more than 1 hour has passed since submission. Use this expression: if…
Sri Ram Kaja 7 months ago +1 verified
Certified Senior Developer

Hi harshc5309 , Please use below code. Here local!proceedButton is a boolean which can be used for showWhen or disable parameter of buttonWidget. a!localVariables( local!submittedTime:datetime(2023…

Parents

0 vikashk0772

Certified Senior Developer

7 months ago

a!localVariables(
  /* Date from DB */
  local!dateTime: todatetime("20/11/2023 09:45"),
  /* Extract time */
  local!time: totime(local!dateTime),
  /* Get hour by having difference */
  local!differnce: tointeger(
    index(
      split(totime(now() - local!time), ":"),
      1,
      null()
    )
  ),
  /* Get the required value based on calculation */
  if(local!differnce >= 1, true, false)
)

Hi harshc5309 , you can create a rule which calculates the difference and based on that you can either show or hide buttons.

Reply

0 vikashk0772

Certified Senior Developer

7 months ago

a!localVariables(
  /* Date from DB */
  local!dateTime: todatetime("20/11/2023 09:45"),
  /* Extract time */
  local!time: totime(local!dateTime),
  /* Get hour by having difference */
  local!differnce: tointeger(
    index(
      split(totime(now() - local!time), ":"),
      1,
      null()
    )
  ),
  /* Get the required value based on calculation */
  if(local!differnce >= 1, true, false)
)

Hi harshc5309 , you can create a rule which calculates the difference and based on that you can either show or hide buttons.

Children

No Data