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?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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.
Photo of Anika

Anika

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
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.
Photo of Meredith Moore

Meredith Moore

  • 556 Points 500 badge 2x thumb
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])