Hi All,
I had a bit of code that ran in the run up to Christmas.
This didn't work after the 1st December passed, the solution was
Now we're in Jan this new bit of code doesn't work and the original does, I can't explain using the immediate window.
It's only so it changes some pictures to a Christmas theme so not major important but I'd like to get it working properly.
Many Thanks
I had a bit of code that ran in the run up to Christmas.
Code:
If Date >= Format("01/12/" & Year(Date), "dd/mm/yyyy") And Date < Format("25/12/" & Year(Date), "dd/mm/yyyy") Then
Code:
Format(Date, "dd/mm/yyyy") >= Format("01/12/" & Year(Date), "dd/mm/yyyy") And Format(Date, "dd/mm/yyyy") < Format("25/12/" & Year(Date), "dd/mm/yyyy") Then
Code:
?Format(Date, "dd/mm/yyyy")
02/01/2020
?Date()
02/01/2020
?Format(Date, "dd/mm/yyyy")>= Format("01/12/" & Year(Date), "dd/mm/yyyy")
True
?Date >= Format("01/12/" & Year(Date), "dd/mm/yyyy")
False
Many Thanks