Quick Base Discussions

Expand all | Collapse all

I want date to = the day the status = completed. How to change a field ""Completed Date"" to the date of when a multiple choice field, containing ""Completed"" is selected?

  • 1.  I want date to = the day the status = completed. How to change a field ""Completed Date"" to the date of when a multiple choice field, containing ""Completed"" is selected?

    Posted 11-18-2016 23:44
    Is there a way to do this without using form rules? I want the 'completed date' to = the day the status is changed to 'completed'.

    I just used Date Modified, ToDate([Date Modified]), for now, but I was wondering if there was a way to do this for when the multiple choice option 'Completed' is chosen so the completed date is changed to that date.


  • 2.  RE: I want date to = the day the status = completed. How to change a field ""Completed Date"" to the date of when a multiple choice field, containing ""Completed"" is selected?

    Posted 11-19-2016 00:20
    If the Status field is not logged, you could do this:

    If(
    [Status]="Completed",ToDate([Date Modified])
    )

    The danger is if the record is modified again on a later date, the later date will show.

    If the Status field is a logged field, you can use Left and Right statements to isolate the date in the text of the logged field.


  • 3.  RE: I want date to = the day the status = completed. How to change a field ""Completed Date"" to the date of when a multiple choice field, containing ""Completed"" is selected?

    Posted 07-28-2017 17:14
    ok but what if there is another condition... (I have no idea why this isn't working.)

    If(
    [Status]="Completed" and IsNull([Date Complete]),ToDate([Date Modified]),[Date Complete])