Error Mismatch.........Can you help

[Oceans Blue]

I can not find out why I am getting that error mismatch?

Can you please help...Attached is a DOC with screen shots and error report

Thanks,
OC

[KavitaPriyaCR]

Hi
I executed your code in my system it's working fine here, try to find out what value you are passing to the function by putting msgbox after the line:
StrDate = DataTable.Value("Date", "Action1")

[A.Saini]

Hi Blue,

The error was due to wrong syntax. you were using StrDatesValue(1) but the correct value should be StrDatesValues(1).

Code:

' The old code is: StrFinalDate = StrDatesValues(0)&StrDatesValue(1)&Right(StrDatesValues(2),2) ' Updated code is: StrFinalDate = StrDatesValues(0)&StrDatesValues(1)&Right(StrDatesValues(2),2)

Hope it will run fine at your end too.

[KavitaPriyaCR]

Yah Saini is right,
while trying out your script i had written the statement correctly here in my system and hence i didn't find that error, executed successfully.
Now i checked it back u were missing that "s", and after deleting that "s" i am also getting that error successfully.