[AccessD] Dividing days into years and months

Gustav Brock gustav at cactus.dk
Wed Jul 28 11:42:23 CDT 2004


Hi Arthur

That's the definition we stick to.

Even when you say "30 days" it means "a month" because in general
terms it means a banking month which counts as 30 days always, giving
360 "days" a year. 

The major difference comes when talking about, say, four weeks or 28
days; that is taking literally.

/gustav


> While on this subject, I'd like to poll the readers for their clients'
> typical definition of a month. In my case, all clients interpret a month
> to mean "increment the month number while preserving the day number; if
> the month is 12, go to 1 and increase the year number". However, some of
> my clients break this rule when the day in question is EoM(): in that
> case they want to go to the next EoM(); i.e., the next date following
> Feb 29, 2004 is March 31, 2004; and conversely, the next date after Jan
> 31, 2004 is Feb 29, 2004.

> Any other non-logical variants?

> Arthur




More information about the AccessD mailing list