How can I return the current date within the SQL editor? The typical mysql/postgres queries don’t work (currdate(), getdate()). Is there a way to use any of the time macros for this?
For context, trying to use the number of days between the current date and a date specified for a calculation.