Share
ReportHi,
I have two Excel sheets from which I extract some data with the "Read from Excel worksheet" function.
From this I want to compare the dates with each other so with a "for each" loop I want to loop over the data from Table1 and compare it with a single date from Table2. If Date1 (from Table1) > Date2 (from Table2) then paste the datarow from Table1 in Table2.
The problem is that both Excels use a different Date formatting. Table1 has a date in "dd/MM/YY hhmmss" and Table2 has a date in "dd/MM/yyyy".
I already tried formatting both Excel tables by selecting the column and then Data -> "Text to columns" -> ... but PAD does not seem to extract this formatted table as dates. If I inspect the extracted data in the PAD UI I notice no difference but when pasted in an empty Excel sheet I can see that some dates are not correct.
It is driving me nuts so help is appreciated 😛
All responses (
Answers (
1,738
