Re: >today() does not work

G wrote: 
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.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Just some guesses:

When you enter the date "manually," it shows up like this, in the
criteria box:

  #4/29/2005#

So, how about using this in the criteria box:

  > "#" & Format(Date(), "mm/dd/yyyy") & "#"

This will return the date as a string value of

  #4/29/2005#

=====

I'm pretty sure the following won't work, but just FYI - the format
works on SQL pass-thru queries.

You may want to use a date format that DB2 may understand.  Try this:

  CRSE_STRT_DT > Format(Date(),"'yyyymmdd'")

The Format() function will return a string of the date formatted like
this:

  '20050429'

Most major SQL DB engines will convert that into their date data type.

Another format, the ISO standard, is this:

  CRSE_STRT_DT > Format(Date(),"'yyyy-mm-dd'")

This will return the date formatted like this:

  '2005-04-29'
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnKcIYechKqOuFEgEQKP1QCg3Vz96KhYZPWF5XtN/pJmLodaRZQAnjtv
pkHwxdmRCB6tJy7IerMWGJ/c
=pu8N
-----END PGP SIGNATURE-----
.

Relevant Pages

  • Re: Why XML to comunicate Distributed Components?
    ... technology as message format. ... Why the communication between components should be ... Which are the benefit of use XML to communicate components? ... case with the real needs of SOAP message format ...
    (comp.object)
  • SUMMARY: growfs
    ... When I went back into format, Solaris had automatically assigned root, swap ... I unmounted the partition, did a growfs to ... This communication is intended for the use of the recipient to which it is ...
    (SunManagers)
  • Re: Chemical bonding inside living vs non-living things
    ... >> GOOGLE'S IMPROVED COMMUNICATION ... >> the words the idiot used to explain its changes. ... the old format is back. ... Google ...
    (sci.chem)
  • Re: Asking if elements in struct arre zero
    ... So you recognize the usefulness of formatted text. ... > communication agree to use some other format that (by accident ... > The point is to maximise communication by minimising barriers to ...
    (comp.lang.c)
  • Re: Top posting
    ... that help should be in a format that they dictate? ... correctly interpret on the part of the recipient. ... the communication of information. ... inhibits the ability of the reader or recipient from interpreting the ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast