|
"Last Report" value seems odd for many countries
the datetime format is not well handled by the Max and Min operators.
The problem appears to be that the dates are being parsed inconsistently by the csvserver dataport. The Max and Min operators are OK. Looking at the actual text stream served by the server: 17/03/2020,17,3,2020,5,0,Afghanistan,AF,AFG,37172386 16/03/2020,16,3,2020,6,0,Afghanistan,AF,AFG,37172386 15/03/2020,15,3,2020,3,0,Afghanistan,AF,AFG,37172386 11/03/2020,11,3,2020,3,0,Afghanistan,AF,AFG,37172386 Open the csv file in the data source and scroll down a bit in the Afghanistan entries to see how the above was parsed. You'll see dates of 3/17/2020, 3/16/2020, 3/15/2020, and then... 11/3/2020. That seems wrong, as though the csvserver dataport insisted on converting the date string into month/day/year and then for the 11/03/2020 date it didn't, and left it in day/month/year. I've reported it. I updated the update query
Yes. You could also do that in Edit - Join, which can update an existing field in the original table from the joined table.
|