Post reply

Setting start and end date parameters to only allow date from same month

  • June 20, 2008 at 8:15 am

    #189466

    Hi,

    I'm trying to set start and end date parameters. They have to be from the same month and year. How can I do that? I'm thinking from the stored procedure, but not sure how.

    Thanks,

    Melissa

  • June 20, 2008 at 9:48 am

    #831916

    With this question do you mean that you want to be able to select a start and end date and then pass these parameters to a SP that will return the relevant data?

  • June 20, 2008 at 10:01 am

    #831920

    Automation-wise - it might be easiest to allow them to pick one date (say - the startdate), and an integer replresenting the day of the other "side", and set up your stored proc to calculate the second date, and then use that in whatever query requires it.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply