Discussions

 View Only
  • 1.  Access the date/time in a logged field?

    Posted 11-09-2020 14:37
    I have several note fields that employ the Log entries option.  Is there any way to get the date and time of the last entry?

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Access the date/time in a logged field?

    Posted 11-09-2020 17:15
    If the new entries are at the bottom of the list, then this formula for a date time formula field will parse out the date/time into a date/ time field type.  You just need to edit the first line to put in your own [field name]. 

    var text DateAndTime = Left(Right([append only with date /time],"["),18);
    var date TheDate = ToDate(Left($DateAndTime," "));
    var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));


    ToTimestamp ($TheDate, $TheTime)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Access the date/time in a logged field?

    Posted 11-10-2020 12:59
    How would I do this based on the most recent completed status?

    ------------------------------
    Nathan Allan
    ------------------------------



  • 4.  RE: Access the date/time in a logged field?

    Posted 11-10-2020 13:40
    Can you post an example

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Access the date/time in a logged field?

    Posted 11-10-2020 13:47
    Yes, here is an example. I'd like to capture the date from the most recent log that says completed so Nov-10-20 12:40 PM instead of the one at 1:11 PM.


    ------------------------------
    Nathan Allan
    ------------------------------



  • 6.  RE: Access the date/time in a logged field?

    Posted 11-10-2020 19:27
    I was in the mood for a puzzle

    // change Completed to a vertical Pipe | character
    // nothing special about the | but it is rarely used by users.
    var text LogWithPipes = SearchAndReplace([Status], "Completed", "|");

    var text RemoveAfterPipe= NotRight($LogWithPipes, "|");
    var text CompletedEntry = Right($RemoveAfterPipe, "[");

    var text DateAndTime = Left($CompletedEntry,18);
    var date TheDate = ToDate(Left($DateAndTime," "));
    var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));


    ToTimestamp ($TheDate, $TheTime)

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Access the date/time in a logged field?

    Posted 11-12-2020 10:13
    Perfect. Thanks a ton!

    ------------------------------
    Nathan Allan
    ------------------------------