Post reply

Parameter setting for DateTime

  • September 21, 2013 at 2:46 pm

    #277466

    I have a StartDateTime parameter for my report and I'd like to always set to 2pm yesterday time.

    The expression I had for default value fails on me and I'd appreciate if anyone can help me to correct it:

    =DateAdd("d",-1,today) + " 2:00PM"

    Thanks in advance!

  • September 21, 2013 at 11:12 pm

    #1652172

    You're missing the "Add 14 hours" part...

    =DateAdd("h",14,DateAdd("d",-1,Today))

  • September 22, 2013 at 1:01 am

    #1652176

    Thanks! 🙂

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

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