I'm currently using this
CDate("1/1/" & Year(Date))
but is there a better way of constructing the date
I need to add date add later and increase the year too but I'm thinking there is a better way than using a string...
I'm currently using this
CDate("1/1/" & Year(Date))
but is there a better way of constructing the date
I need to add date add later and increase the year too but I'm thinking there is a better way than using a string...
I'm thinking
Format(Date, "mm/dd/yyyy", , vbFirstJan1)
but not sure...
Personally, I like to use the following:
Code:DateSerial(Year(Date()),1,1)