Anyone good with Access?

[Dmitry]

I'm taking a quiz and I'm supposed to find the difference between dates, but it's not working for me. What I have so far is:

Days since order: DateDiff("d",[Date()],[Orders]![Order Date])

Where Date() should be found automatically, but it keeps asking me for it. Also doing this in a query.

Please halp bg, I want to go home

[MisterBob]

Googling something simple like this will get you the answer in seconds.

[Tajin]

I believe the function to get current date is Today() but of course I'm going by Excel functions >.>

[Dmitry]

Days since order: DateDiff("d",Date(),[Orders]![Order Date])

I hate this program...

[evilbau]

Days since order: DateDiff("d", [Orders].[Order Date], Date())

http://office.microsoft.com/en-us/acces ... 11033.aspx

I think people need to learn to google?

Google: Access DateDiff syntax