Parameter setting for DateTime

  • 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!

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

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

  • Thanks! 🙂

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

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