[ezRETS-users] DTS packagae with date query

[Greg Crossan]

Worked,  TODAY was exactly what I was after.  Thanks

-----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 1: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