Current date error in Code - MUST BE MODIFIED

[JJFletcher]

Hi,

This code checks if there is any Anniversary today... The issue is the code is seeing today as the same as 01/13/0000 (whatever year) ... it is seeing the 01/13 as November 3rd

Can this below code be modified to prevent this error???

Please Login or Register  to view this content.

Best Regards,

John

[xlbiznes]

Hi,

i tried your code and it works without any issue, can you check the values in the date column.

[JJFletcher]

Thanks for replying - the date column on the sheet is formatted 00/00/0000

[xlbiznes]

Mine is formatted as mm/dd/yyyy .

[JJFletcher]

same with me - mm/dd/yyyy . I just put 000's