[ezRETS-users] DTS packagae with date query

[Mobroten, Peder J]

Try this for MSSQL 2k conversion:

convert(varchar(11), getdate(), 120)


Also, great product Keith!

Peder Mobroten
Systems Developer
Coldwell Banker Burnet
pjmobroten at cbburnet.com
(952)-844-6423


-----Original Message-----
From: ezrets-users-bounces at crt.realtors.org
[mailto:ezrets-users-bounces at crt.realtors.org] On Behalf Of Keith T.
Garner
Sent: Tuesday, May 08, 2007 3:39 PM
To: Support and talk for users of the ezRETS ODBC Driver
Subject: Re: [ezRETS-users] DTS packagae with date query

On 5/8/07 3:14 PM, Greg Crossan wrote:
> I am trying to create a SQL Server DTS package using the EzRets ODBC
> driver with a date range.  I realize that ezrets requires the dates in
a
> '2007-05-08' format, and I am able to get it to pull data if it type
in
> literal text.
>  
> However I need to pull it like this select.. where lasttransdate >=
> getdate()
>  
> how can i convert the function to a literal for exrets..

Honestly, I have no idea.  getdate() is probably a server side function
in
SQL.  Currently, ezRETS doesn't support any server side functionality,
because RETS does.

However, RETS does give us some magic words you can use to get similar
effect.  For dates you can use TODAY and for datetimes you can use NOW.
That's pretty much all RETS allows.  Otherwise, I think you'll need to
do
some VBscripting, of which I am no expert.

Keith

-- 
  Keith T. Garner - Managing Director - Center for REALTOR(r) Technology
   kgarner at realtors.org - 312-329-3294 - http://blog.realtors.org/crt

_______________________________________________
ezRETS-users mailing list
ezRETS-users at crt.realtors.org
http://mail.crt.realtors.org/mailman/listinfo/ezrets-users