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?

Question

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.

davidhawe · Answer

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.

meredithmoore1 · Answer

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])

Forum Discussion

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?

Related Content

How to Completely Prevent "More - Copy this record"

How do I make a formula date field called ""Completion Date"" that captures the date when a multiple choice field called ""Status"" is set to a particular value like ""Complete""?

Generate a "% Complete" tally

How do I make this work? If( IsNull([Date Complete]) and [Status]=""Completed"",ToDate([Date Modified]), [Date Complete])

send notification when all quotes are completed