michael3426
New member
- Local time
- Yesterday, 18:57
- Joined
- Mar 18, 2016
- Messages
- 2
I have a database that I'm trying to make some mods to. I have a field with a last test date, score field, and next test date fields. I am trying to modify the VB code to update the next test date field to the last day of the month. For instance, if someone last tested on April 12th, 2015 and scored a 91. I need the next test date to update to the last day of the month to April 30, 2016. This is the code I have been working with but I think I am missing something. Any assistance would be appreciated!
DateSerial(Year(Date), Month(Date + 1), 12)
or
DateSerial(Year(Date), Month(Date + 12), 0)
DateSerial(Year(Date), Month(Date + 1), 12)
or
DateSerial(Year(Date), Month(Date + 12), 0)