How to send Date from excel to google

excel
studio

#1

Dear friends,

I am trying to read date from excel and trying to put it into google. but UI path is not picking date in “DD/MM/YYYY” format , rather then it is taking “DD/MM/YY 00:00:00” format.Please help me in this.


#2

@aishwary, YourDateVariable.ToString(“dd/MM/yyyy”)

Refer forum for posts regards this.

Regards,
Dominic :slight_smile:


#3

@Dominic Already tried this but rather then taking date its inserting (dd/MM/yyyy) as a string itself.
Like for (“Weather”+" “+bCity+” "+bDaterange.ToString(“dd/MM/yyyy”)+ “[k(enter)]”), it is inserting -----Weather Delhi dd/MM/yy.
Wanted to share xaml but not able to as i am new user :frowning:


#4

@aishwary, Looks Strange !
Even if the bDateRange is in dateTime and has no value it should take 01/01/0001.
It would be helpful if you provide screenshots/Xamls.

Regards,
Dominic :slight_smile:


#5

@Dominic Thanks brother. I got the solution . Actually i was passing incorrect column index due to which i was getting error.
YourDateVariable.ToString(“dd/MM/yyyy”) worked fine for me.

Thanks again! :slight_smile: