Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Nov 09, 2021

Formula for End of Current Year in VBA

  Hello, I have a form and fills in fields based on which button I press.  One of the buttons fills fields as below with current date and I am having an issue populating the field that is the end o...
access
  • isladogs's avatar
    isladogs
    Nov 10, 2021
    PMFJI
    Try DateSerial(Year(Date()),12,31)
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Nov 09, 2021

Tony2021 "...The examples I provided did not work. "


Again, what does that mean? Errors? Wrong values? Describe the behavior, not the outcome. That's where we can spot clues to what might be wrong.

isladogs's avatar
isladogs
MVP
Nov 10, 2021
PMFJI
Try DateSerial(Year(Date()),12,31)
  • Tony2021's avatar
    Tony2021
    Steel Contributor
    Nov 13, 2021
    perfect. thank you very much!
    • isladogs's avatar
      isladogs
      MVP
      Nov 13, 2021
      You're welcome!

Resources