fill date field with date of changing a value in a field

(0) Share

Report

Posted on by ramialhasan

Hey all,

I have option set field (yes and no) and datum field, when the option set field is set to "no", there is nothing th see on datum field, so it is empty. However when the option set field is set to "yes", the datum field should be filled with the datum of this change. ( I set to yes today, that means the date of today should show in date field) and when I look next week in the record, I should see the date of last week, when I had changed it to yes.

Can I achieve this with Workflow? or calculated field?

All responses (4)

Answers (1)

ramialhasan 35 on at

Like (0)

Report

RE: fill date field with date of changing a value in a field

I did it now with caculated field when to modified on, I ll test it until tommorow if it does not work, I will try this approach. Thanks mate
LuHao 40,872 on at

Like (1)

Report

RE: fill date field with date of changing a value in a field

Hi Rami,

We will use workflow to achieve it.

Here is a demo.

There is a two options field 'Yes or no' and a date field 'datum date' on the form.

Create a workflow. Select Scope as Organization, Start When as Record fields change, select the field 'Yes or no'.



Add a Check Condition step, set if the field 'Yes or no' equals No.



Add a Update Record step, set Clear to the field 'datum date'.



Then add a Condition Branch step, set if the field 'Yes or no' equals Yes.



Add a Update Record step, set {Execution Time(Process)} to the field 'datum date'. Note the hierarchical relationship between the steps. Activate this workflow.



Please refer to this blog on how to create a workflow: https://stellarise.com/how-to-create-a-workflow-in-dynamics-365-to-set-the-date-of-an-invoice/
ramialhasan 35 on at

Like (0)

Report

RE: fill date field with date of changing a value in a field

I will do it with modified on date. Thanks
Verified answer

T.I.A 1,760 on at

Like (0)

Report

RE: fill date field with date of changing a value in a field

Yes, you can use a calculated field for this functionality.