Forum Discussion

jeannejeanne's avatar
jeannejeanne
Qrew Cadet
8 years ago

Datetime Stamp for When Status set to a specific status.

I want to a datetime stamp from a multiple choice field when set to a specific status. I do not want to use the log edit method, i want to status to only show the last status chosen. Is this possib...
App builders
Ask about Quickbase functionality
Tables and fields
jeannejeanne's avatar
jeannejeanne
Qrew Cadet
8 years ago

thanks, actually got that working with the log field.  i am getting the date of a specific satus what is the formual to get the user name? can't seem to get that right.  this is what i am using to get date of WIP

    If(Contains([Update Status],"WIP"),
       ToDate(Left(Right(NotRight([Update Status],"WIP"),"["),9)),null)