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 to find an alternative. Basically, I'm looking at creating a calculated field which says:
If (Sum (DATE()-[DueDate]) <0, "Overdue", "Not Overdue")
Any suggestions?
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 to find an alternative. Basically, I'm looking at creating a calculated field which says:
If (Sum (DATE()-[DueDate]) <0, "Overdue", "Not Overdue")
Any suggestions?