about Access built-in function

Question

Why my Access 365 built-in function list has no DateDiff function. How can i add DateDiff function to my Access built-in function?

Answer 1

As Duane Hookom mentioned,you can build a query.

The calculate field may not support this formular.

Answer 2

Hi,

I tried to create one new feild which values type is caculation in one table. This new field values need caculate the difference of Now and another feild value which data type is date. When I enter designer I can't find DateDiff in build in function list.

Answer 3

What do you see if you build a query with any table and add this column

TestDateDiff: DateDiff("d", #1/1/2024#, Date())

Answer 4

Please tell us which version of Access you are using.

Please explain how you are trying to use DateDiff(). In a query? In VBA?

Note that Access Web Apps were deprecated years ago, so it's not very likely that is a factor here.

Answer 5

Hi Zhangjie,

Are you utilizing a web-based version of the Access database?

If so, please be aware that the DateDiff function is not supported in web-based databases.

However, I can direct you to a helpful article that discusses the DateDiff function in detail.

It's applicable to various versions of Access, including Microsoft 365, Access 2021, Access 2019, and Access 2016:

https://support.microsoft.com/en-us/office/datediff-function-e6dd7ee6-3d01-4531-905c-e24fc238f85f 

Best Regards,

Sophia