Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Expression for Dates

    I have a Hire Date field, how can I build an expression that will calculate what the date will be in 45 days from that date in a new field.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    dateadd("d", 45, [Hire Date]) should do the calc for you.

    (i guess you mean "another textbox" rather than "new field")

    currently using SS 2008R2

  3. #3
    Join Date
    Dec 2003
    Thanks so much for your help, I figured it out a little early.
    For anyone else who may have the same question, the easy way to do it is this:

    In the query design view, in the field name I created the expression:


    I renamed the Expr1: to 45 Days:

    It worked perfectly. Thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts