Re: AW 5.1 Question

[Robert Boucher <boucher1@alumni.texas.net>]

In article <C6A06883.CC3E%hughhood@earthlink.net>,
 Hugh Hood <hughhood@earthlink.net> wrote:

> 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.
> 
> 

Thanks to Hugh Hood and Steve Nelson for the solution to my request. It 
was so easy I went back and put a Day indication in several of my 
databases.
> 
> 
> 
> 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?