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

ekje

Registered User.
Local time
Today, 06:19
Joined
Jan 8, 2014
Messages
35
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

Wino Moderator
Staff member
Local time
Today, 06:19
Joined
Aug 30, 2003
Messages
36,134
You should be able to. Have you tried what the message suggested?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:19
Joined
Aug 30, 2003
Messages
36,134
I remembered that I have such a field:

1715707765460.png
 

Users who are viewing this thread

Top Bottom