Get Date/time

Question

Helloooo quickbase community!I have a question, i&nbsp;need to create a field that saves the exact date and time when another chechkbox field is equal to true, I don't need a log I need to know some formula to do this. Thanks again, you are very helpful.Regards,&nbsp;Herberth Solano.------------------------------Herberth Solano------------------------------

markshnier__you · Answer

If you are editing on a form, then you can use a Dynamic Form Rule. First make a Date/ Time field called like [Date / Time checkbox was checked].

Then make a form rule,
When Multiple conditions are true
ALL of
[Date / Time checkbox was checked] is blank (just leave blank)
Checkbox field is checked

Action
Change the value of [Date / Time checkbox was checked] to the current date/time.

If it's possible that your users will be checking the checkbox in Grid Edit, hen you will need to set up a Pipeline to do that. Post back if you need help with that.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

herberthsolano · Answer

I need to estimate hours, so my start time is [Date created] and my end time is when [checkbox field] changes = true.

So I need this last hour to subtract it from [Date created].

------------------------------
Herberth Solano
------------------------------

markshnier__you · Answer

OK, so the start date/time is [Date Created] and the end time is [Date / Time checkbox was checked] .

So to get the number of hours as a numeric formula field type you can subtract and convert to the # of hours.

ToHours([Date / Time checkbox was checked]- [Date Created])

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

herberthsolano · Answer

Is it possible that when [Checkbox field] = true, other fields capture the exact time it was activated ?For exampleif([Checkbox field] = true, now())But the Now() updates it to the current date,&nbsp; not which one was activated.Thank you very much Mark!------------------------------Herberth Solano------------------------------

markshnier__you · Answer

No, you cannot use a formula like that because it will always return the current date/time, and as they say "Time waits for no man", so would just keep changing.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Get Date/time

8 Replies