+LizzyRN Posted January 28, 2020 Share Posted January 28, 2020 Hi, I'm trying to identify caches hidden on a specific month and day. I'm a paying member of Project-GC. I have looked but cannot find how to collect this data. Is it possible? Thanks. Quote Link to comment
+speakers-corner Posted January 28, 2020 Share Posted January 28, 2020 As a premium member you can set up a pocket query for what you are looking for. You can select a date from / to among other things. 1 Quote Link to comment
+Isonzo Karst Posted January 28, 2020 Share Posted January 28, 2020 https://www.geocaching.com/pocket/gcquery.aspx date range is one of the features Quote Link to comment
+Crazedllama Posted January 28, 2020 Share Posted January 28, 2020 Using the Map Hidden Date option in the tools tab on Project GC will help you find a cache on a day and month you haven't. You can also loop that using the add filter option if you have found a cache on that particular day and month already. Quote Link to comment
+LizzyRN Posted January 28, 2020 Author Share Posted January 28, 2020 Thank you all! Quote Link to comment
+LizzyRN Posted January 28, 2020 Author Share Posted January 28, 2020 (edited) Let me be more specific. I left out some important information. I'm looking for caches bidding on February 29 of any year. So far, I have done a PQ year by year, then I combined into a list. I'm wondering if there is a better way. Edited January 28, 2020 by LizzyRN Quote Link to comment
+thebruce0 Posted January 28, 2020 Share Posted January 28, 2020 (edited) In GSAK it can be done if you know a bit of SQLite. If you load a PQ from the region you're looking into GSAK, clear the Search filters, then on the "Where" tab add the text strftime('%m%d',PlacedDate)='0229' - that will filter for caches in the current database that are placed on Feb 29, any year. If you're not using GSAK, it's going to take a lot more effort I'm not sure PGC has a function to search for and list matching caches that way. If you don't use GSAK, you could load the PQ GPX file as plaintext into an editor like Notepad++ (it can handle large files much better than windows Notepad, assuming you're on windows), and search for the hidden date until you find matches. But that'll be a lot more tedious. (but it can be made easier if you know some RegEx syntax, but now we're getting way advanced, heh) Edited January 28, 2020 by thebruce0 Quote Link to comment
+LizzyRN Posted January 29, 2020 Author Share Posted January 29, 2020 Thanks TheBruceO and everyone else who replied. I used a PQ for each Leap Year with the limitations I desired. Then, I created list from those. It was pretty quick and got me exactly what I needed. Now, I'm ready for Leap Day 2020. Quote Link to comment
+GrateBear Posted January 31, 2020 Share Posted January 31, 2020 (edited) Actually, there is a very easy was to do it using GSAK. There's a macro that will do that, called "findBirthdayCaches". Run a PQ of unfound caches (assuming you want a new find), then run the macro for that date. I've been doing that to fill in the "birthday finds" grid. Shows all the caches hidden on that date for all years. Works like a charm. Where I currently am, there is only 1 for 2/29. Hope it's still there and easy to find--won't be happy if I have to wait 4 years for the next one........ Edited January 31, 2020 by GrateBear Add addl info Quote Link to comment
+HHL Posted January 31, 2020 Share Posted January 31, 2020 1 hour ago, GrateBear said: Actually, there is a very easy was to do it using GSAK Yes, thebruce0 described it two posts before yours. 1 Quote Link to comment
+GrateBear Posted February 1, 2020 Share Posted February 1, 2020 1 hour ago, HHL said: Yes, thebruce0 described it two posts before yours. Really? What I read that was posted was: "if you know a bit of SQLite. If you load a PQ from the region you're looking into GSAK, clear the Search filters, then on the "Where" tab add the text strftime('%m%d',PlacedDate)='0229' -" That seems a bit more complicated than using the macro. 1 Quote Link to comment
+thebruce0 Posted February 1, 2020 Share Posted February 1, 2020 (edited) 1. Load a PQ into GSAK. 2. Search Filters - 'Where' tab - paste strftime('%m%d',PlacedDate)='0229' Boom done. (change 0229 to whatever MMDD month/day you wish) Edited February 1, 2020 by thebruce0 Quote Link to comment
+HHL Posted February 1, 2020 Share Posted February 1, 2020 8 hours ago, GrateBear said: complicated Copy and Paste may be complicated for you. An average user will handle that without an issue. Your advice is way more complicated as the user has to - download macro - install the macro - read the macro's releasethread to understand what the macro will do - run the macro Quote Link to comment
+MartyBartfast Posted February 1, 2020 Share Posted February 1, 2020 9 hours ago, thebruce0 said: 1. Load a PQ into GSAK. 2. Search Filters - 'Where' tab - paste strftime('%m%d',PlacedDate)='0229' Boom done. (change 0229 to whatever MMDD month/day you wish) Think the where clause is over complicated, this will achieve the same: PlacedDate like "%-02-29" unless strftime is doing something else clever. Quote Link to comment
+IceColdUK Posted February 1, 2020 Share Posted February 1, 2020 Just now, HHL said: 36 minutes ago, MartyBartfast said: this will achieve the same No, it won't. You have to use single quotes. Seems to be getting complicated. If only there was a macro. ? 3 Quote Link to comment
+MartyBartfast Posted February 1, 2020 Share Posted February 1, 2020 1 hour ago, HHL said: 2 hours ago, MartyBartfast said: this will achieve the same No, it won't. You have to use single quotes. Yes it will. No you don't. Let me demonstrate with a picture: or if you prefer raw SQL: 1 Quote Link to comment
+GrateBear Posted February 2, 2020 Share Posted February 2, 2020 16 hours ago, HHL said: Copy and Paste may be complicated for you. An average user will handle that without an issue. Your advice is way more complicated as the user has to - download macro - install the macro - read the macro's releasethread to understand what the macro will do - run the macro So, it seems that you have to go through your little solution each time, as opposed to just running the macro once it's installed. And, there is absolutely no reason to read the release thread if you understand what "find Birthday caches" means. I guess that could confuse some people. We can't all be as blessed as you! Quote Link to comment
+MartyBartfast Posted February 2, 2020 Share Posted February 2, 2020 (edited) 6 hours ago, GrateBear said: So, it seems that you have to go through your little solution each time, as opposed to just running the macro once it's installed. In actual fact there's very little difference in the effort required for either solution (though I would say the effort required for step 1 is greater for the macro option) :- install macro once run macro every time select the date in the macro see list of chosen caches vs create a saved search filter as described above once open search every time change the dates in the "where tab" see list of chosen caches. There's a British saying "there's more than one way to skin a cat", and while achieving this task is so simple and obvious to me (using method 2) that I would never consider looking for or using a macro, I get it that the macro option is better for others, and that's the reason why a lot of macros were created by the community - to help people do things which they might otherwise find complicated or difficult. So I think we should accept that two very good and equally acceptable solutions have been offered here and not try to "big up" one over the other as they are both equally effective. BTW I would also apply the cat analogy to the use of ' vs " in SQL statements Edited February 2, 2020 by MartyBartfast 1 Quote Link to comment
+thebruce0 Posted February 3, 2020 Share Posted February 3, 2020 On 2/1/2020 at 6:38 AM, MartyBartfast said: Think the where clause is over complicated, this will achieve the same: PlacedDate like "%-02-29" unless strftime is doing something else clever. That's one thing I haven't checked though - does PlacedDate appear different with localized date formats? Your solution assumes SQLite will always treat the PlacedDate field as a "YYYY-MM-DD" string as a default. The strftime function ensures the string output will always be the same format via %m%d. But if it is always the same format regardless of localized date, then yep yours would work and is less 'technical' to read Quote Link to comment
+The Jester Posted February 3, 2020 Share Posted February 3, 2020 3 hours ago, thebruce0 said: That's one thing I haven't checked though - does PlacedDate appear different with localized date formats? Your solution assumes SQLite will always treat the PlacedDate field as a "YYYY-MM-DD" string as a default. The strftime function ensures the string output will always be the same format via %m%d. But if it is always the same format regardless of localized date, then yep yours would work and is less 'technical' to read I believe the date is stored in a set manner, display of the date is dependent on local format. As to which is easier, SQL and the Where tab are pretty recent additions to GSAK. I haven't checked the date the macro was written, but it could easily predate the SQL/Where option. Non-technical users of GASK may find the entering a date to a macro is easier than understanding the SQL and changing that. Quote Link to comment
+thebruce0 Posted February 3, 2020 Share Posted February 3, 2020 11 minutes ago, The Jester said: As to which is easier, SQL and the Where tab are pretty recent additions to GSAK. I haven't checked the date the macro was written, but it could easily predate the SQL/Where option. Non-technical users of GASK may find the entering a date to a macro is easier than understanding the SQL and changing that. That's why I suggested the where tab option - because in this case, it's cut and paste and the only thing you need to change, if you want, is the month and date value (0229). No worrying about syntax or localization, and it's incorporated into the existing basic filter workflow without needing to load another macro But yes, people find different things easy. But it's a technically simple option to very quickly filter and view your database for a specific month/day match - one of a few entirely reasonable options. 1 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.