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

AMD Radeon Adrenalin release date, new features, compatible graphics cards

6 great UX design talks you can watch online

How to jailbreak an iPhone or iPad in iOS 11 or iOS 10

Musique de Noël : les meilleures chansons en streaming