Re: DATE Datatype in SQL View

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Ron

Elvis can give you more - used to work with him - but here's my take 
- basically you need to get your date into a valid date format and 
put the DATE function around it. The format that will always work is 
yyyy-mm-dd - not slashes - so you have some concatenating of substrings to do,

Vern

At 12:06 AM 2/25/2007, you wrote:

> Currently, it is Alpha 10.
>
> Funny, I was just looking thru some Centerfield's newsletters and the
> examples you had in there.
>
>
>
> On 2/24/07, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> >
> > What's your field's current format?
> >
> > Celebrating 10-Years of SQL Performance Excellence
> >
> >
> > --
> > Ron Adams
> --
> 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.