Results 1 to 3 of 3

Thread: [RESOLVED] how can i display a date 1 month forward or 3 month forward according to the date now

  1. #1

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Resolved [RESOLVED] how can i display a date 1 month forward or 3 month forward according to the date now

    i tried some many ways can figure how
    e.x if today is 18/12/2014 so i need the datepicker to display 3 months from now 18/03/2015
    Code:
    Dim D As Date
    D = Format(Now, "DD/MM/YYYY")
    Dt1Month.Value = DateSerial(Year(Date), Month(Date) + D, 1)
    Dt3Months.Value = D + 3
    hope you get the picture
    tnx in advanced
    salsa31

  2. #2
    Addicted Member Wolfgang Enzinger's Avatar
    Join Date
    Apr 2014
    Location
    Munich, Germany
    Posts
    160

    Re: how can i display a date 1 month forward or 3 month forward according to the date

    Quote Originally Posted by salsa31 View Post
    e.x if today is 18/12/2014 so i need the datepicker to display 3 months from now 18/03/2015
    Most likely what you are looking for is this:

    Code:
    DateAdd("m", 3, Now())
    Wolfgang

  3. #3

    Thread Starter
    Enjoy the moment
    Join Date
    Feb 2011
    Location
    Barrio Del pilar madrid spain
    Posts
    5,204

    Re: how can i display a date 1 month forward or 3 month forward according to the date

    tnk you very much Wolf

Posting Permissions

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



Click Here to Expand Forum to Full Width