Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I make several fields auto-populate/calculate with different time elapses, all dependent upon a single start date and time?


Level 1

When we have an incident, we start the clock.  We have certain tasks and notifications that must be done within a certain amount of time (5 minutes, 4 hours, 24 hours, 30 days, etc.).  I am pretty good at everything I have tried in LCD ES4, and I have been able to get the date fields to correctly calculate any number of days, but only as date fields.  I think we need to use a date/time field.  Many of the answers I have found do not specify what to do with the script/string/etc. (add as a calculation using Java or FormCalc or as a validation script...).  All of my attempts either don’t understand that there are 60 minutes to an hour, or when I try the Time2Num scripts, I get nothing or something like H2.

0 Replies