This is a date-type data, I want to add a custom column to calculate the month difference between the current time and this date.I did not find a function in the document that can do this, how can I achieve this requirement?
Thanks everyone.
Hi Jesse,
I think you'll have to go with Native SQL and use the date difference function of your SQL engine. For instance DATEDIFF('month',[the_date_field],Now()) with PostgreSQL.