date function in code

[matrixknow]

I have tested the date function to get the last date in a month in a sheet, it works.

Please Login or Register  to view this content.

When I try do include the function in my code along the VBE, the compiler refuse to take the function ?

Please Login or Register  to view this content.

I have tried , and ; as syntaxis.

[royUK]

Have you declared lastdatemonth as a variable?

Are you trying to create a UDF?

[matrixknow]

Please Login or Register  to view this content.

what do you mean by UDF (undefined function ?)

its seems that in code, excel only accept date() without arguments ?

[antoka05]

Try to use this instruction:

Please Login or Register  to view this content.

,
for example, to have data of 7 days ago:

Please Login or Register  to view this content.

Regards,
Antonio