Hello All,
I have a bit of a database and am using the BASE front end. I would like to be able to calculate the difference between the “startdate” and today. its easy enough in a query:
SELECT “table1”.“startdate”, DATEDIFF(day, “startdate”, CURRENT_DATE) FROM “Table1”
I just can’t figure out how to get that query onto a form and into a label or text box. It does not need to go into a data field in a table.
Thank you in advance.