OK - date-diff shouldn’t be difficult, so please pardon me if this is obvious and I’m missing this.
I want to know the number of days between a value in a table and today. Why doesn’t this work:
SELECT birth_date, Date_Diff(‘Day’,date (birth_date), Current_Date) as mydatediff
? Seems simple - replace the ‘birth_date’ with any date in any table. What am I missing?