Re: AW 5.1 Question

[Hugh Hood <hughhood@earthlink.net>]

Fellas,

Robert found an error in the formula I previously posted to provide a
Day-of-Week-from-Date function in the AppleWorks 5.1 database.

I forgot to account for the rounding error introduced with the
multiplication and division.

This will fix it.

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

Hugh Hood




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