Hi, I connected a table to my Mongo database fine. I want to let a user modify dates on each record.
I set up a column with column type Datepicker. Set the calculation to = {{currentRow.publishedOn}}
to pull in the default date, but see Invalid date in the date picker.
Also added an action "Save date" to save the newly selected date and have it running a query updateOne with { $set: { publishedOn: {{ postsTable.data[i].newPublishedOn}}
I think the error is in how I'm trying to select data from Retool because when I hard code values, the query runs fine and successfully saves.