in

 

Setting default date of a date prompt to todays date

Last post 03-06-2008 11:24 AM by dallen. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-19-2007 8:30 PM

    • Jezza
    • Top 75 Contributor
    • Joined on 12-16-2007
    • Perth, WA
    • Posts 13

    Setting default date of a date prompt to todays date

    I would like to set the default date of a date prompt to todays date. Anyone know how to do this

     Thanks

  • 01-16-2008 7:37 PM In reply to

    Re: Setting default date of a date prompt to todays date

    Jezza,

    I have asked around to a number of people at Daptiv and no one can figure out how to accomplish this.  The Create Date provides today's date for a dynamic application automatically but cannot be used for DateDiff calculations in dynamic applications because this function is not available.  The DateDiff calculation can be made by using the WI solution in a report and you can have the Create Date and other date fields in each entry to accomplish your needs. 

    John F. Filicetti, PMP, MBA
  • 03-06-2008 11:24 AM In reply to

    • dallen
    • Top 75 Contributor
    • Joined on 10-19-2006
    • Seattle
    • Posts 10

    Re: Setting default date of a date prompt to todays date

    You can create a parameter in the filter section of the query that looks like this:

    [Start Date] = ?current_date?

    You can replace start date with whatever date field you want to use as the filter in the report:  ?current_date? is a function in cognos that returns the current date and the question marks define that as a parameter.  Then when you create the prompt page, reference this parameter in your date prompt and you will see the current date display as the default.

     Hope this answers your question.

     

    Dave Allen 

    Dave Allen
    Program Manager - Daptiv
    Filed under:
Page 1 of 1 (3 items)

Navigate: Home | Blogs | Forums | Solution Library  Get Help:  Contact | Feedback | FAQ   Terms of Use:  Terms & Conditions | Privacy Policy