Hi. I uploaded a csv list made up of two columns. First column is day and month (dd/MM, ex. 07/12) and second column is names of people (in this case, dead persons of an organization). I want to get the names of persons who died today. The result is uneven. Sometimes I only get the correct names, other times I also receive names who have died on a different day of a different month, without any logic. I checked the csv list and it is correct. Where is the problem? Thanks for your help.
You need to re-format your dates so that they are sortable
07/12 >> 2024-12-07
thanks. But in that case I have to change the app every year. I wanted an app that can be used every year. Also, I cannot use 2024 in the first column of the list because people died in different years.
Also Clock1 is formatting today as a text string: ex. 12/12 and it is comparing this string with the column 1 in my list which is a text string. Why should it make an error in comparing strings?
04/12
03/07
05/01
which one will come first if you sort them (bear in mind that these are strings and not date numbers...
Yes. I had set the string of the first column to look in the European way (dd/MM). After your suggestion, I have reformatted the first column (MM-dd) and also instruct Clock1 to format today's date in the same way and now it seems to work. I hope. Thank you very much for your help.
Your list handling looks clumsy, like an eggshell omelette.
(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.
The advanced list blocks would reduce your code considerably.