Web database expression: number of days between a field and todays date - How?

[Lincoln]

How do I write a Access 2010 Web database expression to give me the number of days between a particular field eg [sold date] and todays date?
Being a Web database I know I am restricted to a smaller list of available expressions - normally part of my expression woud include eg date().


Can any one help?

[orange]

Do some investigation of the DateDiff() function.

Here's a sttart http://www.techonthenet.com/access/f...e/datediff.php

[Lincoln]

Do some investigation of the DateDiff() function.

Here's a sttart http://www.techonthenet.com/access/f...e/datediff.php

Hi there Orange

I do know about the dateDiff() function and tried again to use this, but a web-based selection of expression doesnt include DateDiff() or date() or now() !! Any suggestions?

[orange]

I don 't have acc2010, and don't have any suggestions.

This seems a real shortcoming, I hope someone has an answer for you.
a web-based selection of expression doesnt include DateDiff() or date() or now()