I had issues due to a little-noticed mishap with ref. dates. I regularly import CSV files exported from Apple Numbers where I set the date to the format YYYY-MM-DD. in applying the date format in Ragic! design mode, I had set the format to this custom format and I didn’t realize this was causing the problem! The format with the dashes, I believe, is also easier to read than the one with the slashes.
According to this Ragic! reference article here : https://na3.ragic.com/conradAssets/start?q=date%20format the ISO date format is yyyy/MM/dd (not exactly sure of the capitalized MM either).
According to at least this Wikipedia article (https://en.wikipedia.org/wiki/ISO_8601) the format with the dashes is the ISO format, meaning the Apple Numbers date format is correct. Wherein lies the confusion?!
Can we get some clarity on this? Ordinarily, I would not have raised the issue but I spent considerable time trying to figure out why some of my date calculations were not working (such as records not showing in Calendar reports. The problem went away when I fixed the dates to the yyyy/mm/dd format). The Ragic! documentation needs to be updated to address the error (and of course, the yyyy-mm-dd conveniently missing from the preset date formats in Ragic! needs to be updated as well).
Thank you!
Kenneth