Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: How to Set Current Date to user passed date

    Hi ,

    i'm using Next30days Function in crystal reports 9.0,

    i want to set currentdate to userinput date.

    pls help me

  2. #2
    Join Date
    Dec 2004
    Location
    Connecticut
    Posts
    85

    How about DateAdd?

    Assuming you've got a parameter field UserInputDate, set your selection criteria to use the DateAdd function on the parameter.

    Something like

    {DateField}>={?UserInputDate} and {DateField} <= DateAdd("d",30,{?UserInputDate})

    should return all records for 30 days including the UserInputDate. Play with the operators ( >, <, <=, and >= )to include or exclude the first and last days in the range.

Posting Permissions

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