Create datevalue in Parameter

• jvElecenter

  SSCarpal Tunnel

  Points: 4502

  More actions

  December 11, 2007 at 8:08 am

  #177497

  Hi

  I have this expression builtin in default value, Non-queried,

  =DateAdd("day",-30,Today)

  My parameter is a datetime type.

  Meaning is to have a date 30 days before today.

  I've already tried it with Now()

  In stored procedured I've used this with getdate() and it works fine.

  Anybody got any clue ?

  Thx in advance

  El Jefe

  
  JV

• Niklas Hendrikson

  Old Hand

  Points: 301

  More actions

  December 11, 2007 at 8:43 am

  #758998

  Hello,

  Enter this in the default values:

  =DateAdd("d",-30,Today)

  The change is that I am using "d" instead of "day".

  Niklas