Creating a calculated field using fields of type date/time (1 Viewer)


Registered User.
Jan 8, 2014
It's about an error message in the Microsoft Access database. The table contains the fields "Holiday_StartDate" and "Holiday_EndDate". When I tried to create a calculated field "HolidayLength" whose value would be " Holiday_EndDate" - "Holiday_StartDate" I got the following error message: " You cannot set "HolidayLength" to the Calculated data type. You can add a new field instead"

Is it not possible to create a calculated field when the calculated fields are type of date/time in Access?

Please reply to me as soon as possible.
Thank you for your quick reply!
You should be able to. Have you tried what the message suggested?
I remembered that I have such a field:


Users who are viewing this thread

Top Bottom