Hi This thread appears to be very close to what I need & Brian's suggestion of using "Dateserial(Year(Date()),1,1)" I think is the answer I need but am unsure where to insert it or what would need to be replaced in the code I have.
If someone could advise I would be grateful.
The code I have...