On 11/13/10 4:55 PM, Peter Haworth wrote:
The dates are coming from an SQL database, so they are in -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.
Thanks. I forgot that I have been using the SQLite strftime function
to do all my date formatting/calculations so I think I'll just use that.
Pete Haworth
On Nov 14, 2010, at 12:35 PM, J. Landman Gay wrote:
On 11/13/10 4:55 PM, Peter Haworth wrote:
The dates are coming from an SQL
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
On 11/13/10 1:44 PM, Peter Haworth p...@mollysrevenge.com 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
That sounds simpler! I've never used convert and dateitems - what
format would tdate have to be in?
Pete Haworth
On Nov 13, 2010, at 2:42 PM, Dick Kriesel wrote:
On 11/13/10 1:44 PM, Peter Haworth p...@mollysrevenge.com wrote:
I'm using the datetimetoJulian function in Sarah's great
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
The dates are coming from an SQL database, so they are in -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