You may want to Dim the GetDate and GetDate2 as Date
Dim GetDate as Date
Dim GetDate2 as Date
This is just a shot in the dark..

"BTW" wrote:

O, and when I put a watch on Value and value2, it says that the value
is not defined in the expression...so did i write down the "getdate"
values on a wrong way?

BTW

BTW schreef:

Hi Alok

the error code I get is error code 5:

"invalid procedure call or argument"

Strange it works at your pc!

BTW