I'm trying to create a new table of dates of the first and last day of the month.
The date range for this new table is from the "Date Created" field of a separate table (Table 1) which is from an external data source.
I'd like the new table to be dynamic so that as Table 1 is updated, the date list is also updated.
This must be possible, but I don't know where to start?
The date range for this new table is from the "Date Created" field of a separate table (Table 1) which is from an external data source.
I'd like the new table to be dynamic so that as Table 1 is updated, the date list is also updated.
This must be possible, but I don't know where to start?