Default parameter to today's date

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  July 18, 2014 at 2:03 am

  #291171

  Hi

  I'm Using VS 2010 and working on a SSRS report, I have one parameter that I want to set it to current date, I tried =dateadd("d",-1,today()) but I get some errors.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 18, 2014 at 12:51 pm

  #1730740

  That expression get's yesterday's date not today's date. I usually just use =Today() as the expression to get today.

  What error are getting?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question