Hello, total noob here using Retool for basic functions. Im trying to get the Calendar presentation component to read a date and display it as an event.
I've made an app which uses the date input component to add a simple date into a postgresql column. The column in the db is set as a date type.
The date inserts to the db just fine and I can manipulate it in normal tables for different formats, etc but for some reason the calendar component reads the entire ...is it 4 bytes?... DDMMYYYYTHH:MM:SS.-whatever. But no matter how I change the date ( be it through trying different queries or moment(), etc.) the calendar will list the date as an event but followed by "invalid date".
Seems to be a conflict between the creation date and the actual value of the db cell...?
Its really that simple to duplicate. Single column table as a date type, add a date using the date input component, and then read that table from a query using the calendar presentation component.
Any advice would be greatly appreciated.