Yetiforcecrm: [Question] How do I make a condition true when the date in the field is before today

[vdpawel]

How to make the condition in Workflows, so that it is true, as the date of the field is before today?

eg If today is 21/10/2020, the date is in the field

• 10/10/2020 will give the result TRUE
• 20/10/2020 will give the result TRUE
• 22/10/2020 will give the result FALSE
• 29/10/2020 will give the result FALSE

Do I have to enter any formula in the "in less than" field?

I wonder if this effect can be achieved with the available functions?

[vdpawel]

[davide-alghi]

Hi @vdpawel,

_1) =============================== with today excluded_ ===============================

---

_2) =============================== with today included_ ===============================

[vdpawel]

It works!!!
@davide-alghi Thank you very much for your time

Can in a similar way, I can get the following effect, I can not find a solution.

Case 1:

Case 2:

The solution for case 2 will be AND of your solution and case 1. Is there any simpler solution?

[davide-alghi]

Hi,
about your last two cases, for case 1 is

---

about case 2, it's not clear. Have you to run workflow if

field_1 (02.10.2020) < TODAY (now) < field_2 (30.10.2020)

where field_1 and field_2 are two date fields into entity?

[vdpawel]

@davide-alghi Thank you very much for your answer, now the conditions are clear.
Case 2 is 2 fields, eg

field_1 (02.10.2020) <= TODAY (now) < field_2 (30.10.2020)
Start Data <= TODAY (now) < Target Date.

Referring to your examples, I would do it like this:

[davide-alghi]

yes that's right :thumbsup: