Re: SQL Date Math

You have to convert mydate into ISO date format
something like this if query/400:

DIGITS(mydate) ... to get it into alpha form
then you substring mm then dd then yy with '/' between each substring

That's what I was looking for! Thanks Alan...

Hmmm...also...what if mydate is 8.0 numeric in the form of ccyymmdd?

On Nov 13, 2007 12:24 PM, Alan Shore <AlanShore@xxxxxxxx> wrote:
>
> OR
>
> try
> mydate between current_date and current_date - 30 day
>
>
>
> Alan Shore
>
> NBTY, Inc
> (631) 244-2000 ext. 5019
> AShore@xxxxxxxx
> "If you're going through Hell, keep going" - Winston Churchill
>
>
>
> "Michael Ryan"
> <michaelrtr@gmail
> .com> To
> Sent by: "Midrange Systems Technical
> midrange-l-bounce Discussion"
> s@xxxxxxxxxxxx <MIDRANGE-l@xxxxxxxxxxxx>
> cc
>
> 11/13/2007 12:19 Subject
> PM SQL Date Math
>
>
> Please respond to
> Midrange Systems
> Technical
> Discussion
> <midrange-l@midra
> nge.com>
>
>
>
>
>
>
>
> Bah...this is eluding me. I want to select records from a file where a
> date value is between current date and 30 days ago. I thought I could
> do something like:
> mydate between current_date and current_date - 30, but that doesn't
> seem to work. Gotta be easy...how do I do it? Thanks!
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.