Date range - today date within the date range

[joannasokolowska]

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

[Ladarthure · Accepted solution]

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 solution]

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. 

[joannasokolowska]

Perfect! thank you!