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
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(
currentDateTime() - submissionDateTime > 1 hour,true,
)current DateTime get your current date and time
submissionDateTime shows your form's submitted date and time.currentDateTime() - submissionDateTime , calculate the difference between these times.
1 hour is a threshold you want to check against. if your time difference is greater than 1 hour, the condition is true. then it will eveluate to true, and you can use this condition to visibility of proceed button.
Hi harshc5309 ,
Please use below code. Here local!proceedButton is a boolean which can be used for showWhen or disable parameter of buttonWidget.
/* Date from DB */
local!dateTime: todatetime("20/11/2023 09:45"),
/* Extract time */
/* Get hour by having difference */
split(totime(now() - local!time), ":"),
/* 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.
© 2023 Appian. All rights reserved.