Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
3 years ago

Comparing Dates

I have a due date field for a task that is auto-populated based on the start date of a project.
When the task is complete I want the user to select; "Yes, No, "N/A"  AND I want to keep "Log Edits" on this field.
What I cannot figure out is how to extract the date out of the field with "Log Edits" and compare that with the date in the auto-populated field.
Are these the same? Are these not the same?

------------------------------
Hans Hamm
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Here are some of my cheat motes on parsing out elements of append only fields.

    Parsing Append Only Fields

    so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.

    Most recent value (formula text field type)

    Trim(Right([my update field],"]"))

    Date of most recent update (this needs to be a formula date field)

    ToDate(Left(Right([my update field],"["),9))

    Who did the most recent update (formula text field type)

    Trim(NotLeft(Left(Right([my update field],"["),"]"),9))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • HansHamm's avatar
      HansHamm
      Qrew Assistant Captain
      3 years ago
      Well leave to good ole Mark to come to my rescue! Worked like a charm!
      Thank you sir

      ------------------------------
      Hans Hamm
      ------------------------------