Date calculations in Access

  glyn f 20:47 06 Sep 03

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 03

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.

Microsoft Surface PC release date, price and specs: All-in-one Surface PC to directly rival iMac

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

Apple's event invitations decoded: A look back at 16 of Apple's most cryptic invites | Clues in…