Results 1 to 4 of 4

Thread: If you can answer this...

  1. Jun 15th, 2000, 12:09 AM #1
    ALFA117
    ALFA117 is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2000
    Posts
    18
    Is it possible to scan a database, for a field that match the following statement??:
    Month(field) = Month(date) and Day(field) = Day(Date)
    (I want the program to get the fields that match with the current day)

    Reply With Quote Reply With Quote
  2. Jun 15th, 2000, 02:01 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    What DBMS are you using?
    Reply With Quote Reply With Quote
  3. Jun 15th, 2000, 03:47 AM #3
    ALFA117
    ALFA117 is offline

    Thread Starter
    Junior Member
    Join Date
    Jun 2000
    Posts
    18
    DAO 3.6
    Reply With Quote Reply With Quote
  4. Jun 15th, 2000, 03:56 AM #4
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Access, aka Jet.

    I've never done it but you should be able to use the format command.

    For example:

    select * from table where Format([HireDate],"m")=12 and
    Format([HireDate],"d")=25

    should get a hiredate of 12/25
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width