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

[ekje]

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!

 

[pbaldy]

You should be able to. Have you tried what the message suggested?

 

[pbaldy]

I remembered that I have such a field: