Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Mar 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    generating report problem

    can you help me? how do you generate a date range report script base on a specific. For example, if i want to display a report in the month of june from 2004 to 2005 or in the month of july from 2002 to 2003? Thanx

  • #2
    Regular Coder
    Join Date
    Sep 2005
    Posts
    394
    Thanks
    1
    Thanked 0 Times in 0 Posts
    This isn't a very helpfull question. What are you generating from where?

    ~Phil~

  • #3
    $object->toCD-R(LP); vinyl-junkie's Avatar
    Join Date
    Jun 2003
    Posts
    3,092
    Thanks
    2
    Thanked 23 Times in 23 Posts
    Are you trying to figure out how to write the query to retrieve this kind of data from your database? If so, here's one way of doing that.

    Code:
    Select * from tablename
    where mydate between '2004-06-01' and '2005-06-30'
    Music Around The World - Collecting tips, trade
    and want lists, album reviews, & more
    SNAP to it!


  •  

    Posting Permissions

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