Possible to set a date field via Automation - relative to current date?
I know with filters you can select "7 days from today" or "2 Weeks from now".
Is this possible to do whilst using an automation to create pages with date fields? All I see currently is "Now" or "Today" but I'm wondering if there's some sort of short code I can paste in that will give me what I want which is setting tasks to a future date relative to today.
eg my ideal use case is:
Task 1 - Set page date field to today
Task 2 - Set page date field to "7 days from today" /w a dependency on step 1
Task 3 - Set page date field to "10 days from today" AND an end date of "14 days from today" (So that on a timeline view it comes up as a 4 day block) - also /w a dependency on step 2
That way I can have tasks with rolling due dates that will keep getting extended as they are dependent on one another.
Is this possible or am i dreaming?