Getting the weekday name
Peter Haworth
pete at mollysrevenge.com
Sat Nov 13 17:55:25 EST 2010
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
>
More information about the use-livecode
mailing list