from to date as parameter

  • hi there

    How can I prevent that the end date choosen is before the start date ?

    Kind regards


    JV

  • If the report is based on a stored procedure, you can handle it there. Either raise an error, or change the To Date to something that makes sense.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • hi thx for the quick response

    In fact it is a sp.

    How should I handle it there ?


    JV

  • Use Raiserror to raise an error and have the front-end capture that and alert the user.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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