Recent content by 0weavern

Thanks marlan, My main problem is the NOW() & DATE() functions don't work in web tables, so have nothing to DateDiff with. It needs to be a calculated field which looks at today's date and the due date and flags if it's overdue. Hope that makes sense?

Hi All, First post, so please be kind! I've created a web access database which uses SharePoint to host. I need to add in an "overdue" field into a table but having some problems with the calculated field. I know the DATE() and NOW() functions are not compatible with web tables but can't seem...