Jim,
i love it!
It's definitively good extention for creating SQL-queries
for monthly, yearly (and quarterly) reports and relating things.

----- Original Message -----
From: "Jim Starkey" <jas@...>
To: "Gregory Deatz" <gdeatz@...>; "Ann Harrison"
<harrison@...>; <chris@...>; "Paul Beach"
<pabeach@...>; <IB-Architect@yahoogroups.com>
Sent: Monday, October 29, 2001 6:55 PM
Subject: [IB-Architect] Date Conversions and Arithmetic


> I've just implemented a cute hack: the manefest constants
> "thismonth", "thisyear", and "thisday" in date string.
> The conversion code recognizes things of the forms:
>
> thismonth [+/- <number>]
> thisyear [+/- <number>]
> thisday [+/- <number>]
>
> in date strings where a month, year, or day could otherwise be
> used.
>
> "thismonth 1" is the first of this month
> "thismonth+1 0" is the last of this month
> "thismonth thisday+7" is next week
> "thismonth 0" is the last day of last month
> "thismonth+2 25" is Chrismas (if you read this in Oct.)
> "thismonth" is the last day of last month (think about it)
>
> obvious the normal validation checking is turned off -- month,
> yea years, rollover as required.
>
> Ann is lobbying for "thisquarter" as well. The jury is still out
> on that one.
>
> Thoughts? Comments? Love it? Hate it?
>
> Jim Starkey
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>