• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

How find last date of month of last year after entering the first date of a month of this year

I want to populate a form field with the last date of month of last year after entering the first date of a month of this year.  SO if I enter 10/1/2017 in the 1st field I want 10/31/2016 to populate the 2nd field.
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
dateserial(year(Date)-1,Month(date)+1,0)

=dateserial(year(txtStartDate)-1,Month(txtstartdate)+1,0)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now