The following code produces the date to one week ahead. I want it to produce dates associated with all values of “week”.
I have tried inserting the key value “week” into the following code. This creates If I could replace “dur(1 week)” with "dur(“week” week) but this produces a dataview error.
TABLE WITHOUT ID
week, date(2023-01-02) + dur(1 week) as "Date after start"
SORT week ASC
What I’m trying to do
I am trying to create a table that shows a date calculated from a numeric key value “week”. “week” indicates week from start and I would like the table to show the date corresponding 1, 2 3, … weeks from the start.