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

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
this is my excel format
image

@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

@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

@sarathic

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

Cheers

Hi
@sarathic

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

Thanks
Shree

Hi @Shripad_Sarwate

It’s not working