Error when formatting date...not sure why

[ST4RCUTTER]

For some odd reason this code works in one workbook but not in another. Any idea what might be causing this? The error I receive is:

Compile Error:

Wrong number of arguments or invalid property assignment.


I am baffled because it works in some cases but not in all. Here is the code:

Please Login or Register  to view this content.

[boylejob]

ST4RCUTTER,

Do you have CurrDate defined in a specific way such as string, number, date, etc.

Just thinking out loud.

[ST4RCUTTER]

I did define it as a Date value. I decided to go another route so this problem is no longer an issue.