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?

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

T.I.A 1,760 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ramialhasan 35 on at

Like (0)

Report
Copy link

Link copied!

I will do it with modified on date. Thanks

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (1)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
ramialhasan 35 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No