Getting the weekday name

[Peter Haworth]

The dates are coming from an SQL database, so they are in yyyy-mm-dd  
format - will that work or do I need to convert them to some other  
dat?  I already have a function that converts the SQL dates to the  
external format mm/dd/yy if that would work better.

Pete Haworth

On Nov 13, 2010, at 2:46 PM, J. Landman Gay wrote:

> On 11/13/10 3:44 PM, Peter Haworth wrote:
>> I'm using the datetimetoJulian function in Sarah's great datetime  
>> stack
>> as part of a way to get the alpha weekday name. The words in Sarah's
>> stack say that it's possible to get the day number of the week by  
>> taking
>> the remainder of dividing the Julian days by 7 but when I do that, I
>> consistently get a day number that is 2 less than it should be -  
>> that's
>> assuming of course that day 1 would be Sunday.
>>
>> I can always just add 2 to the day number but wondering if anyone  
>> knows
>> why this would happen?
>
> Just curious, do you really need Julian dates? If you already have  
> an existing date in a valid format, it should convert to the long  
> date successfully. That has the alpha day of the week as the first  
> item.
>
> -- 
> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
> HyperActive Software           |     http://www.hyperactivesw.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>