DateAdd issue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kshbat
    New Member
    • Jul 2008
    • 1

    DateAdd issue

    Hi,

    I have 2 fields, one is Operation Date which is the Current Date, the other field is Value Date, whish should be the Operation Date + 1 Day. Can you help me with the expression plz.
    Thx.
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Code:
    Me.[Value Date] = DateAdd("d",1,Me.[Operation Date])
    The square brackets are necessary because you apparently have spaces in your object names. This is a very bad idea! Instead use something like OperationDate and ValueDate or Operation_Date and Value_Date

    Welcome to Bytes!

    Linq ;0)>

    Comment

    Working...