Multiple Assign: Can not assign 'Split(date_of_birth, "/ ")(1)' to 'month'. issue

Help Activities
,
1

Hi
I am trying to date extract from the excel and select the date from date picker. But when I give the it with multiple assign activity it’s not run and show the error message as

“Multiple Assign: Can not assign ‘Split(date_of_birth, "/ ")(1)’ to ‘month’”

Please help me to resolve this.

image
image1481×665 151 KB

image
this is my excel format
image

2

@sarathic

If you open exception details from locals panel you would see the exact error…looks like either your variable is empty or not having any / in it

And for dates you can use Cdate(Date_of_birth).Month.ToString to get the month value

Cheers

3

@Anil_G ,
Sorry for the late rply. did you mean without using the split. I want to select different date month and year . Thats why i am trying to taking it from excel

image
image1462×683 56.2 KB

4

@sarathic

Please try logging the variable…looks like there is no space as well

Cheers

5

Hi
@sarathic

Try Following solution
year=date_of_birth.split("/“c)(2)
month=date_of_birth.split(”/"c)(1)

Thanks
Shree

6

Hi @Shripad_Sarwate

It’s not working