Date calculations in Access

  glyn f 20:47 06 Sep 2003

I am creating a database to store details of when particular properties are empty of not - this means that the 'date vacated' field is often empty (because someone is living there!). Although I can use the date() instruction to calculate the number of days a property was occupied as of today,I need to be able to calculate date values at a specific date (year end, month end, etc) Although I can obtain these figures by the simple expedient of re-setting the PC Clock, for obvious reasons I cannot hand this over to my client!

Can anyone help?

Glyn Foster

  Forum Editor 02:11 07 Sep 2003

in the Helproom where it will do better, and I'll move it there now.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HTC U12 Plus review: Hands-on

Best Android emulators for Mac

TV & Streaming : comment regarder Roland Garros ?