Access 2019 Date function problem

Mr. LAI Long Chau Vitus 1

The Access 2019 fail to using date function, such as date(), year(), month(). Is it some I missing or needed attention?

Albert Kallal 5,226 Reputation points

2021-02-14T20:02:14.517+00:00

While in the VBA code editor, do a debug->compile from the menu. Does the code and project compile?