Is there a way to create a current time formula. We have to put in the time as of right now. it would be nice to have it do it for us.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Photo of Charles

Charles

  • 0 Points

Posted 4 years ago

  • 0
  • 1
The function for the current date/time is Now()
The function for the current time of day is ToTimeOfDay(Now())

Where are you trying to have the time put?
Photo of Charles

Charles

  • 0 Points
I am trying to make a field that lets people know when we set them a ticket. So ToTimeOfDay(now()) is what I am looking for. I just couldn't figure how how to write it. Im still new to QB
Photo of Charles

Charles

  • 0 Points
So the now() keep change with the time and date. for example. Yesterday I made the ticket but it now has todays date and time instead of yesterdays. So it changes with it. Is there away to make it not do that?
QuickBase has built in automatic fields for the [Date Created] and [Date Modified].  These are actually date/time field types.  It sounds like you can use the [Date Created] field to get the time your ticket was Created.