Date range - today date within the date range

Question

Dear Colleagues,

I need your advice regarding workflow I am trying to create.

I have a date range and deadline columns. Workflow should check if today date is within the range and if yes then take the appropriate deadline (e.g. for today it should be 2021-01-30).

Please look at the data input in the attached workflow.

Thank you in advance!

Asia

Date range.yxmd

Ladarthure · Accepted Answer

Hi @joannasokolowska,

I did a sample workflow to parse the date range and a basic rule, you can adapt it if needed!

Emil_Kos · Accepted Answer

Hi @joannasokolowska,

I have prepared a workflow for you:

This is checking the date if it is in this date range provided in column deadline.

If you want to make it work for today's data you would need to change the deadline column to use DateTime now.

In the workflow, you have two solutions one for deadline column and second for today's date.