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 | [email protected]
HyperActive Software | http://www.hyperactivesw.com
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
