Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Count months instead of days.

Discussion in 'Information Technology' started by Nick, Jul 28, 2006.

  1. Nick

    Nick
    Expand Collapse
    Guest

    I have a field in a form that coducts the following calculation. =[Event
    Date]+180 How do I get it to count calendar months instead of days? I
    appreciate any help.
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---The Accountant Theatre, Movies & Cinema Oct 21, 2016
    Gurmat Vichaar | Futility Of Counting Paaths | April 12, 2016 Gurmat Vichaar Apr 23, 2016
    wolf count Blogs Oct 17, 2015
    recount Blogs Oct 17, 2015
    Events Banda Singh Bahadur's Martyrdom - An Eyewitness Account History of Sikhism Mar 26, 2015

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Use the DateAdd function.

    =DateAdd("m", 1, [Event Date]) will add 1 month, =DateAdd("m", 2, [Event
    Date]) will add 2, and so on.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Nick" <Nick@discussions.microsoft.com> wrote in message
    news:18F10474-1592-4E26-98D6-4C4ED2DD6DFD@microsoft.com...
    > I have a field in a form that coducts the following calculation. =[Event
    > Date]+180 How do I get it to count calendar months instead of days? I
    > appreciate any help.
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Try this --
    DateDiff([Date1Field],[Date2Field],"m")

    "Nick" wrote:

    > I have a field in a form that coducts the following calculation. =[Event
    > Date]+180 How do I get it to count calendar months instead of days? I
    > appreciate any help.
     
  5. Ron2006

    Ron2006
    Expand Collapse
    Guest

    And

    =DateAdd("m", -1, [Event Date]) will subtract 1 month,
    =DateAdd("m", -2, [Event Date]) will subtract 2 months,

    and so on.
     

Share This Page