How to check whether cell value is double or datetime variable by if activity

excel
activities
variable

#1

I would like to put condition in if activity that checks the format of cell value
especially whether its double or datetime.

What should I write as a condition.

quick response will be very much appreciated!!


#2

hi @Seonyong

if(row(index value).toString.contains(double var) or row(index value).tostring.Contains(datetime var)

for date time you can covert.tostring("")

Thanks
Ashwin S


#3

Thank u so much! helped much


#4

Oh but there is a question mark after using this, i think UIPATH doesnt understand var


#5

hi @Seonyong

don’t use var give some variable name

I was telling you as an example

Thanks
Ashwin S