Grouping by - repeated values

[Lindsay_Patross]

I've been creating long automation to add a list of tasks every time we get a new project. I create one automation and then add a step for each new task. 

I just saw the repeating groups function and I wanted to try this. 

So I added a table called "Tasks for automation" 

I need to be able to set the task due date to be a calculation based on the project due date. Each task will have a different due date.

Task 1: Due Date = project due date - 28 days. 

Is there anyway to create a date from a calculation 

[Jason_Hill]

Assuming {due date} is a date/time field, you can create a new field called {project due date} and set it to a formula field. You can use this formula: DATETIME_PARSE({due date}) - 28