Re: AW 5.1 Question

[Hugh Hood <hughhood@earthlink.net>]

Robert,

Sure, Randy really improved the DB before the plug got pulled.

Since the DB has no 'MOD' function, it is necessary to roll your own, but
that's really no big deal.

Here's the formula to enter in the DB via the <OA-O> 'Options' menu.

          
@Choose(((@DateToJul([Date]))/7-@Int((@DateToJul([Date]))/7)*7)+1,"Fri","Sat
","Sun","Mon","Tue","Wed","Thu")


Enter it as shown with _all_ parentheses or it will not work.

The reference to '[Date]' may change if you call your date field something
else, but remember that the word 'date' should be in the field name
somewhere.

Finally, be sure to set your date field to 'Auto-Recalc' so that whenever
the date is entered or is changed the formula for the day of the week will
be refreshed.

Hugh...

Again, AppleWorks may call its dates 'Julian', but actually its dating
system begins 01/01/1904.





in article boucher1-358840.07525806082009@news-wc.giganews.com, Robert
Boucher at boucher1@alumni.texas.net wrote on 8/6/09 7:52 AM:

> In article <C69FC1CB.3099%hughhood@earthlink.net>,
>  Hugh Hood <hughhood@earthlink.net> wrote:
> 
>> Fellas,
>> 
>> AppleWorks 5.1 eats this stuff up. Not only can you do this with a dot
>> command macro, you can do it in the spreadsheet using just the @mod and
>> @choose commands.
>> 
>> AppleWorks 5.1 begins its internal numerical date clock on January 1, 1904,
>> with a designation of '0'. This day in history happened to be a Friday.
>> 
>> Today is August 5, 2009, a Wednesday, which AppleWorks internally designates
>> as the number '38568'.
>> 
>> So, just put this formula in a spreadsheet cell to give you the named day:
>> 
>>    @CHOOSE(@MOD(A1,7)+1,"Fri","Sat","Sun","Mon","Tue","Wed","Thu")
>> 
>> 'A1' is a reference to your date cell. Normally you'll have this formatted
>> in your preferred date setting, rather than as just the internal numerical
>> designation.
>> 
>> This should work until weeks are something other than 7 days long.
>> 
>> Hugh...
> 
> What about a database?
>> 
>> 
>> 
>> in article boucher1-A4F67D.07404804082009@news-wc.giganews.com, Robert
>> Boucher at boucher1@alumni.texas.net wrote on 8/4/09 7:40 AM:
>> 
>>> Is there a way, formula wise, to get a named day from a date in
>>> Appleworks 5.1, i.e., Aug 4, 2009 is Tue?