Is there a way to calculate a due date (60 hours) based on another date/time entered?
The specific scenario is I have a cooler that is packed with ice on 30JAN2024 at 1300. It expires in 60 hours. I want that date/time to automatically be entered.
The date fields are formatted as dd-mmm-yyyy; the time fields are formatted as HH:MM
OK, then you can use this code as the custom calculation script of "Expiration Date":
var packedDateString = this.getField("Packed Date").valueAsString;
var packedTimeString = this.getField("Packed Time").valueAsString;
if (packedDateString=="" || packedTimeString=="") {
event.value = "";
this.getField("Expiration Time").value = "";
} else {
var expDate = util.scand("dd-mm-yyyy HH:MM", packedDateString + " " + packedTimeString);
expDate.setTime(expDate.getTime()+(60*3600000));
event.value = util.printd("dd-mm-yyyy", expDate);
this.getField("Expiration Time").value = util.printd("HH:MM", expDate);
}Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices