RE: >today() does not work

I was able to do a workaround like this:

keep: IIf([CRSE_STRT_DT]>=Date(),Yes,No)
criteria = yes

Evidently it is a communication issue between DB2 and ACCESS. If anyone
knows how to resolve the communication issue (i.e. through references or
something), then I would appreciate it greatly.

--
Thank you in advance for your assistance. It is greatly appreciated.


"G" wrote:

> When I use >Date() to get all records greater than today, I get the following
> error message.
> ODBC--call failed.
> [IBM][CLI Driver][DB2]SQL0181N The string representation of a datetime value
> is out of range SQLSTATE=22007 (#-181)
>
> However, if I put in today's date manually, it works fine. Is this due to
> references or something like that?
>
> Thanks,
> G
> --
> Thank you in advance for your assistance. It is greatly appreciated.
.

Relevant Pages

  • RE: SLIP sliding away
    ... Try running the DB2 DIAGNOSE MEPL utility. ... The information contained in this communication is confidential, ...
    (bit.listserv.ibm-main)
  • Re: how many bugs do you find and correct during TDD?
    ... > Ilja Preuß wrote: ... >> I didn't understand Ron to be complaining, ... Communication is hard, and often the way we interprete a message says at ... The only references I can give you are the german works of Schulz von Thun ...
    (comp.object)
  • demande daide
    ... Abidjan-Côte D'Ivoire.Je vous prie d'emblée de ... du droit d'assistance humanitaire qu'une confiance ...
    (Debian-User)
  • RE: Performance Tuning of batch insert and batch update using JDBC API.
    ... how exactly are you doing the DB2 9 ... Is it truly an insert or is it a "load" operation that is "not ... intended recipient, you are hereby notified that any reproduction, ... If you have received this communication in error, ...
    (comp.databases.informix)
  • Re: What math class to take to catch up on Modulus and DLP?
    ... > Normally flame wars arise from a breakdown in communication. ... > cipher design he failed to cite any references to back up his point. ...
    (sci.crypt)
Quantcast