Post reply

SSRS default value Time Expression

  • October 31, 2013 at 3:59 pm

    #281882

    Hi All,

    I got two dropdowns in SSRS report

    StartTime and EndTime

    StartTime always should take default values as 7 Days from Today and Time should be as 00:00AM but Time part should not be visible

    default EndTime should be today and time should be taken as 23:59:00 PM. this time part also should not be visible

    Example: The actual selection should be as

    StartTime

    10/24/2013 00:00:00

    EndTime

    10/31/2013 23:59:00

    -----------------------------------------------------------------------

    But it should only display

    StartTime

    10/24/2013

    EndTime

    10/31/2013

    How to achieve this

    Thanks,

  • November 5, 2013 at 2:48 am

    #1664073

    I haven't tried this but have you looked for an option of formatting the date before it pulls into drop down something with expression like: "=Format(Now(), "MM/dd/yyyy")"

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

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