Db-why-not
Registered User.
- Local time
- Today, 15:52
- Joined
- Sep 17, 2019
- Messages
- 159
Hello,
I Have 4 fields with dates and times. Time field is in Military time. Fields: US_date, US_time, CXR_date, CXR_time. I want to create 3 calculated fields using those other fields to determine how many hours apart each of the date, times are. Calculated fields: 24hr_before, 24hr_after, more_24hr. I want the calculated fields to show up as a 1 if it's TRUE or 0 if false.
If the cxr_date is within 24 hours before us_date, then 24hr_before field would be true and should show up with a "1", the other 2 fields will show up as "0"
Would I have to concate (combine)the dates and times together first in another field before I could do this calculation? Any help would be appreciated. I'm a newbie with access.
I Have 4 fields with dates and times. Time field is in Military time. Fields: US_date, US_time, CXR_date, CXR_time. I want to create 3 calculated fields using those other fields to determine how many hours apart each of the date, times are. Calculated fields: 24hr_before, 24hr_after, more_24hr. I want the calculated fields to show up as a 1 if it's TRUE or 0 if false.
If the cxr_date is within 24 hours before us_date, then 24hr_before field would be true and should show up with a "1", the other 2 fields will show up as "0"
Would I have to concate (combine)the dates and times together first in another field before I could do this calculation? Any help would be appreciated. I'm a newbie with access.